Thanks Peter..

SELECT *

from Metatags WHERE

'|' + MetatagDesc + '|' LIKE '%|2|%'

If the field contains 2|23|4 , and am searching 23, its shud search only 23 not...