Will
Case When var_number IN (10)
get the correct result?
Thank you.
Solved
How to check if a number starts with 10? this number might consists of any number of digits '1023456789', the most important thing it starts with 10 and i don't care about the rest.
Best answer by manuel.wetze
This is highly dependent on the datatype of your column.
I would use
CASE WHEN
LEFT(var_number,2)='10' THEN 'yes'
ELSE 'no'
but this assums that varnumber is a string already. If not you have to make it one using TO_STRING.
+8This is highly dependent on the datatype of your column.
I would use
CASE WHEN
LEFT(var_number,2)='10' THEN 'yes'
ELSE 'no'
but this assums that varnumber is a string already. If not you have to make it one using TO_STRING.
This is highly dependent on the datatype of your column.
I would use
CASE WHEN
LEFT(var_number,2)='10' THEN 'yes'
ELSE 'no'
but this assums that varnumber is a string already. If not you have to make it one using TO_STRING.
Thank you for your reply!
The data type is CHAR. I think it might work with Char, otherwise I will convert it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.