How to determine if string starts with Alpha or Numeric

[kristyparker_concur]

Hello,

I am trying to determine if a string starts with a number. This is what I am trying to say...

CASE WHEN [Level 2] starts with *number* THEN ([Level 3] + [Level 2]) ELSE '' END

I can't figure out how to say 'starts with a number' though...

Any help is appreciated!
Thank you

[dougp]

You're using + as a string concatenation operator, so I'll assume you are using SQL Server.

Code Select Expand

case
when isnumeric(substring ([Level 2], 1, 1)) = 1 then [Level 3] + [Level 2]
else ''
end

[kristyparker_concur]

Yay! That was it.

Thank you so much!
Kristy