can i use like in a if statement i am tring to display everything that begins with letter L
if objrs.Fields("serv_code") like "%L" then
response.write objrs.fields("serv_status")
if objrs.Fields("serv_code") <> like "L" then
response.write objrs.fields("serv_status1")
my serv_code fields contain L01, L02, L03, L04, S01, S02, S03, T01, T02 and so on