Hi.

Have been a silent spectator of the forum for a while..

had a quick question.

can the LIKE be used with the Wildcard only at the beginning of the data.

for example, I need all records ending with 6343.

I Tried using
select (*) from abcd
where
Account LIKE '%6343'

but am not getting any records.

using like

select (*) from abcd
where
Account LIKE '%6343%'


lists all records containing 6343 which is not the result set i am looking for.

any suggestions?


thanks

This could happen if the ACCOUNT column is defined as CHAR, in which case it may contain trailing spaces to fill the column value to the specified length. Try "RTRIM(ACCOUNT) LIKE '%6343'".

thanks a lot..

now i feel dumb :P