Using SUBSTR() would be better then using INSTR()

code:

select
case substr(@wksta,1,2) = "DC"
...
case substr(@wksta,1,2) = "VA"
...
case 1
...
endselect


Bryce

------------------
kix.isorg.net

[This message has been edited by Bryce (edited 05 April 2001).]