How can I SELECT COLUMNS LIKE '%SOMETHING%'?

[yosiasz]

Looks like you have asked a similar question many times before but might not have bothered to look at the answers

How can I search for fields and tables that match a wildcard?

Hello! I want to search/select fields and tables that match a wildcard. For example: SELECT LIKE [Col1%] FROM LIKE TABLE1% Is that possible? Thanks!