Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Remove non alpha chars from a column RE: Remove non alpha chars from a column
bgalway
Ten Centuries
Points: 1158
More actions
September 30, 2014 at 1:48 pm
#1749254
Not sure if this query extract is helpful but it helped me in a recent situation where I was trying to deal with non-alpha characters:
WHERE ([Bill Freq] IS NOT NULL) AND ([Bill Freq] NOT LIKE '^[A-Za-z0-9]+$') AND ([Bill Freq] NOT LIKE '')