SQL Query how to select entry by char count?

by Evgelen 12. December 2009 21:55

SELECT * FROM TableName WHERE len(ColumnName) > 100

8de05fe4-59e1-417a-b891-5c48f2b195ce|1|5.0

SELECT * FROM TABLE WHERE column is like ..

by Evgelen 23. November 2009 22:36

  SELECT * 
  FROM [Database].[dbo].[Table]
  WHERE ColumnName Like 'Name%'

41b206b2-3d5a-488f-ab5f-8cc3f9878e58|1|5.0