SELECT QUERY

[Steve1001]

Hi

I have a table with sample number, which is alpha numeric and can be 4 or more charactures long. How can I make a query that will select on say 3 or more of these ?

Many thanks


Steve

 

[Guest_imported]

Hi Steve,
Could you be just a little more elaborate? A couple of examples will help us.

 

[AtomicWedgie]

Try using the left, mid or right argument in your query

For instance

select samplenumber form sample
output: 1234567

select left(samplenumebr,4) from sample
output: 1234 (this selects first 4 characters)

select right(samplenumber,5) from sample
output: 34567 (this selects the last 5 characters)