Cpc classification

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Tyna
Posts: 3
Joined: Tue Jun 13, 2017 7:21 pm

Cpc classification

Post by Tyna » Thu Jul 13, 2017 3:48 pm

Hey,
Can you tell me please if it is correct to put in my query: left (cpc_class_symbol,4) in ('y02B', 'y02c', 'y02e').
I would like to obtain all the patents with these CPC codes and all subcodes.
what is the difference if i put cpc_class_symbol in ('y02B', 'y02c', 'y02e')

Thank you from advance


mkracker
Posts: 84
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Cpc classification

Post by mkracker » Wed Jul 19, 2017 6:58 am

Hi,

CPC classification codes are always used on the group level, like 'Y02E 20/16', so they contain 11 or more characters. Your code sample

Code: Select all

cpc_class_symbol in ('y02B', 'y02c', 'y02e')
is equivalent to

Code: Select all

cpc_class_symbol = 'y02B' OR 
cpc_class_symbol = 'y02c' OR 
cpc_class_symbol = 'y02e'
Strings of different lengths (like length 11 compared with length 4) is always false, so your query will return nothing.

On the other hand, the SQL function LEFT, e. g. "left('Y02E 20/16',4)", returns the 4 leftmost characters, which are 'Y02E' in our example. So your condition

Code: Select all

left (cpc_class_symbol, 4) in ('y02B', 'y02c', 'y02e'). 
looks good.
-------------------------------------------
Martin Kracker / EPO PATSTAT


Post Reply