String Comparison, Please Help!!!!!!

[Modica82]

Hi all,

i am having great problems, the true SQL guy has left and i have been left to pick up from him, i dont really know SQL Server that well, i have got some experience of SProcs and bits and pieces but i am struggling with this one.

I have a form in an access database that takes in two client codes (Which are text) so for instance one may be ABC the second DBA. what i need to do is in the SQL Query return all the values between these two text fields, so for instance

ABC
ACC
BAB
CAB
DBA

(if these where the only values required!)

Any ideas on how i can do this??

Rob

 

[JayKusch]

Are you running this against a SQL Server table?

Thanks

J. Kusch