how to point to table column in sql server 1

[suna]

i have an input (say "P1T1&quot and I only need the last two letter (in this case "T1&quot to point to another column in another table..

supposedly, when the input is P1T1 then i'll have to go to column T1 to read the result. the same goes to P1T2, P1T3 and so on,..it will go to columns T2, T3 and so on respectively.

I am using
Function tanggagaji(tg)
tangga1 = Mid(tg, 3, 2)
End Function

to get the last two letters. but i don't know how to do the rest!

 

[hellferret]

You could generate an SQL statement like this:

sqlStr="SELECT " & tanggal & " FROM tablename"