sql query if exist then return ID of particular table

lejo

3y874SQL

in my table Department is stored like that -tbl_Attachment - '65cb4b38-2c81-4951-8c1a-93236efb96a1,0b9d1142-64dd-4022-8f4c-0f4e8b34ab81,484c1eda-10ac-45ca-970e-fea730cf98a8,cb4ff124-e6fe-4b29-be81-aabe48befa7e,1974d21d-25f0-47bf-b2a2-aadd9cb4cc2d'

i want to check - cb4ff124-e6fe-4b29-be81-aabe48befa7e this particular ID exist in the above Grouped values

sql query if exist then return ID of particular table

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Yadav3y ago

SELECT ID
FROM tbl_Attachment
WHERE Department LIKE '%cb4ff124-e6fe-4b29-be81-aabe48befa7e%'