Help me

[irishvber]

I have a request number which is made up of a 4 digit sheet number and then a 2 digits that represent the location.
I want to query a database on the 2 digits representing the location to retrieve a textual representtion of the number. Anyway I could do this

Sir Stupidhead

[Hack]

How is the number formatted? An example please.

If the two digits you are looking for are the last two, or the first two, it would be a snap to parse them out of the six digit string.

[msimmons]

If the #'s are at the end of the request number:
SELECT * FROM thetable WHERE requestnumber LIKE '%15'

If the #'s are at the begining of the request number:
SELECT * FROM thetable WHERE requestnumber LIKE '15%'

If the #'s are in the middle of the request number:
SELECT * FROM thetable WHERE requestnumber LIKE '%15%'

Hope that helped
Michael

[irishvber]

Ok the number is at the end ie.....................5656 for the sheet number and 12 for the location. This number is entered together onto a form as 565612. I want to be able to take the last 2 digits i.e 12 and query a table for the location name been represeted by the digit 12 and store this in another txtbox.

hope this makes it easier

thanks for your help

[msimmons]

What I posted should work or if you want to make it more exact and you know it will always be a 6 digit number with the last two being the ones you want you can do it like this:
SELECT * FROM thetable WHERE requestnumber LIKE '____15'
(thats 4 underscores "_ _ _ _" w/o the spaces)
Michael

[irishvber]

anymore help????