srafi78
asked on
Extract only non numeric values from a column of datatype varchar.
I have a table column of varchar type that has a numeric and non numeric values, I want to create a view that gets only the non numeric values from the column.
MyTable
Location List
01
AB
35
02
03
X
09
ABC
I want the view to return Location List with AB, X and ABC values only and leave out all the numeric values.
Thanks!
MyTable
Location List
01
AB
35
02
03
X
09
ABC
I want the view to return Location List with AB, X and ABC values only and leave out all the numeric values.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forget my post, I just read the original post properly!
ASKER
Thanks! that was very helpful....
FROM MyTable
WHERE ISNUMERIC([Location List]) = 1
will also pick up decimal numbers and spaces and stuff.