Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 SELECT columns with similar names

Author  Topic 

urmas80
Starting Member

20 Posts

Posted - 2014-09-07 : 03:09:26
Hi All,

This question might sound like a lazy person query but it's actually could help me allot. :)

For a table with sequencing column names like in the example:

id name a1 a2 a3 a4 b1 b2 b3

can i set a simple select query that will get me all the a% columns?

Thank you in advance,

Uri
   

- Advertisement -