Hi,
How can I only select numeric data from a varchar field that consists of both numeric and string data?
Example:
Column Name contains the following data:
23546
16565
43546
Jeff
John
Jack
How can I only display the following, is there a function in sql server that does that?
23546
16565
43546
How can I only select numeric data from a varchar field that consists of both numeric and string data?
Example:
Column Name contains the following data:
23546
16565
43546
Jeff
John
Jack
How can I only display the following, is there a function in sql server that does that?
23546
16565
43546