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: 407
sql
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