How do you trim in like clause of sql
SuzieNov 12 2007 — edited Nov 12 2007I have some data say %1234 but i want to do a select on it and in the where clause I want to trim the trailing spaces how can I do that... I want to trim the trailing spaces so that when i select I only look for %1234
not '%1234 '
so can do this
select * from test_table where test_d like trim('%1234 ');