MS Access question

AsSiMiLaTeD

I'm pulling a field into a query and need to ignore the first 5 characters of the field. The field may be different lengths, but it's always going to be more than 5 characters and I always need to ignore the first 5.

Is there a trim function that I can use? I'm familiar with TRIM() but I think that only works for leading spaces or zeroes, not what I need.

I know we've got some programmers in here, thought I'd see if anyone can help.

cnjvh

Try:

Like "*querytext"

where querytext is whatever your actually searching for

bradm6406

Try this....

SELECT MID(my_column, 6)
FROM my_table

or if you want the spaces gone too...

SELECT MID(TRIM(my_column), 6)
FROM my_table



Brad

AsSiMiLaTeD

Thanks Brad, exactly what I was looking for...I knew there had to be some syntax for it...