SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • Find Alphanumerals only

    Sometimes when you import data from other system, you may need to clean the data by removing unwanted data. Consider you import data where you want to keep only those which are purely alphanumerals. Here is a way to find out declare @table table ( data varchar ( 20 )) Insert into @table select '23498'...
    Posted to Madhivanan (Weblog) by Madhivanan on Mon, Feb 16 2009
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems