Manipulation of data

[Hendy]

I have a database field that tells me the name of the pc that a user last logged onto i.e. Lcomp1414. I want to be able to able to display London if the computer name beings with an "L". If "E"(comp1234) they are logged on at our other site.

Thanks
Mark

 

[Geee]

Try

If LEFT(RS("COMPUTERNAME&quot,1) = "L" Then Location="London" Else Location="Not London"

Hope This Helps...

G
-GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[Hendy]

Thanks. I was a bit too quick off the mark and did it another way but thanks for you help