var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: please HELP for writing sql statement!!!!!
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.
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'
Thank you so much Andy
Originally Posted by ARWinner