Find SQL Column Not Start with Number or Numeric

If you want to find SQL Column that dose not start with Numbers of Numeric here is the Query.


Select Address From Corporation
where Address  Not LIKE '[0-9]%';

If you want to find SQL Column that start with Numbers of Numeric here is the Query.

Select Address from Corporation
where Address  LIKE '[0-9]%';

SQL Query Convert CSV Column to Rows

Suppose we have Comma Separated value in Column and want to convert to Row

SQL Query to Covert ItemID into Row
 

SELECT Distinct AreaID, RequestID,

Split.a.value('.', 'VARCHAR(100)') AS ItemID , ModifiedDate, CreatedDate

FROM (SELECT

CAST ('<M>' + REPLACE([ItemID], ',', '</M><M>') + '</M>' AS XML)

AS ItemID , RequestID , AreaID , ModifiedDate, CreatedDate

FROM RequestItems_Graphics) AS A CROSS APPLY ItemID.nodes ('/M') AS Split(a)


Result