Removing characters from a alphanumeric field SQL

Posted by LS on Stack Overflow See other posts from Stack Overflow or by LS
Published on 2010-03-15T14:56:54Z Indexed on 2010/03/15 14:59 UTC
Read the original article Hit count: 399

Filed under:

Im moving data from one table to another using insert into. in the select bit need to transfer from column with characters and numerical in to another with only the numerical. The original column is in varchar format.

original column -
ABC100 XYZ:200 DD2000

Wanted column 100 200 2000

Cant write a function because cant have a function in side select statement when inserting

© Stack Overflow or respective owner

Related posts about sql