|
|
Posted by Hugo Kornelis on 05/20/06 00:57
On 19 May 2006 05:44:05 -0700, SQL wrote:
>--This should return only 2's that are not part of a bigger number
>select * from tbl_listids where PropertyID like '%,2,%' OR
>PropertyID like '2,%'
>or PropertyID like '%,2'
Hi Denis,
Or (shorter)
SELECT something
FROM listids
WHERE ',' + PropertyID + ',' LIKE '%,2,%'
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|