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
Cpc classification
Re: Cpc classification
Hi,
CPC classification codes are always used on the group level, like 'Y02E 20/16', so they contain 11 or more characters. Your code sampleis equivalent to 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 looks good.
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')
Code: Select all
cpc_class_symbol = 'y02B' OR
cpc_class_symbol = 'y02c' OR
cpc_class_symbol = 'y02e'
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').
-------------------------------------------
Martin Kracker / EPO
Martin Kracker / EPO
Re: Cpc classification
Hi,
Thank you for your helpful answer.
Best regards
Thank you for your helpful answer.
Best regards