Hey,

I'm writing queries against DB2 v8.1.0.36.
db2level returns 'Instance "DB2" uses "32" bits and DB2 code release "SQL08010" with level identifier "01010106".

I have a 60 character column called "Class".
The values in "Class" are Basic, Advanced, Basic-EXT, Advanced-EXT.
I need to identify only those values that end with "-EXT".

I had thought that I could use SUBSTR but I'm not providing the correct syntax to identify the start position which needs to the the length - 2.

SUBSTR (Class, LENGTH(RTRIM(Class))-2,2)

It does process SUBSTR (Class, LENGTH(RTRIM(Class)),2) but I only get 'T' back.

Any ideas?

Many Thanks!

You are computing the length of the string after any trailing blanks have been removed, but you are not removing them from the base string. Try something like: substr(rtrim(class),length(rtrim(class))-2,2)

Andy

If you only need to identify them why not use LIKE '%-EXT'

Thanks to both of you for your advice. The LIKE '%-EXT%' got me what I needed.

Preesh.....