Prev: How to construct check constraint to allow only one 'True' flag per vendor
Next: 'Invalid object name' for temp table when executing a SP
From: Erland Sommarskog on 7 Jul 2008 04:42
Viccu (Viccu(a)discussions.microsoft.com) writes:
> Thank you, but I need a Select Query on Distinct values and there could be
> data entered with space in future.

If that is your concern, you should remodel the table, to have the date
and the comments in separate columns.

I don't know how those comments are formed, but who says that there always
is a colon? And always in the same position?


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
First  |  Prev  | 
Pages: 1 2 3 4
Prev: How to construct check constraint to allow only one 'True' flag per vendor
Next: 'Invalid object name' for temp table when executing a SP