Simple select/ where condition

[raji96]

I have a column(col1) which has values like
1-Apple
2-Orange
3-Grapes
I need to check if 1 is in the database,
but since the value is stored as 1-apple how can I compare it to 1.

Thanks!

 

[carp]

Try
WHERE substr(mycolumn,1,2) = '1-';

 

[sem]

If you need to extract "numeric" part of some string value, try this:

select
to_number
(substr
(col, 1, length(col)-length(ltrim(col, '0123456789')))
)
from tab



Regards, Dima

 

[dsanchez2]

Try

WHERE mycolumn LIKE '1-%'