Hi All,

I use db2 v8.2.3 and aix 5.2

I need to retrive some last name that have unkown space before "MR" from "LAST_NAME (varchar (128)) column of table TAB1.

e.g.

select last_name from TAB1 where last_name like ' '||MR ;

BUT I do not know the number of spaces before MR, do we have any function?

Thank you in advance for your help

Maybe something like:

where ltrim(last_name) = 'MR" and last_name <> 'MR'

Andy

Thank you so much Andy