SSMS query editing: possible to remove a field and have the matching value removed?

Question

I work with large queries in SSMS. It would be fantastic if I could easily match up the comma-separated values with the comma-separated field names. I often delete a field, and then have to hunt for the matching value before the query is valid again.

Surely there is a way to find the matching value.

Answer 1

Have you tried something like this:

SELECT ColumnName
FROM TableName
WHERE ','+ColumnName+',' LIKE '%,searchword,%'

Or:

SELECT ColumnName
FROM TableName
WHERE
ColumnName LIKE '%,' + @searchword + ',%' 
OR ColumnName LIKE @searchword + ',%' 
OR ColumnName LIKE '%,' + @searchword 
OR ColumnName =  @searchword

Hope this helps