to co chces je sice kravina, ale ked to tak velmi chces, tak riesenie:

declare @string nvarchar(max) = ''
declare @cmd nvarchar(max)
select @string = @string + sc.name + ','
from sys.columns sc
inner join sys.tables st
	on st.object_id = sc.object_id
where st.name = 'NazovTvojejTabulky' and sc.name like 'ab%'

set @cmd = 'select ' + left(@string, LEN(@string) - 1) + ' from NazovTvojejTabulky'

exec( @cmd )