without 'LIKE'?

General
Enthusiast

without 'LIKE'?

Hi frnds!
Can anybody tell me solution for this--

select all the names in a column which are starting with letter 'b' . but without using 'LIKE' operator?

Vamsi.
2 REPLIES
Enthusiast

Re: without 'LIKE'?

how about something like ....
select
column1
from table1
where substring(column1 from 1 for 1) ='b'
Enthusiast

Re: without 'LIKE'?

Hi Blaine VandeBerg!
Its working.Thank you very much for your support.