please help with a select query

[nqobile]

I have a numeric field with eight digits and
I would like to select records where the first five digits are specified and the other three can be any i.e 13201###. When criteria is '13201#' and '13201###' it gives an error message saying 'data type mismatch in criteria expression'.
Please help.

 

[KenReay]

Hi

Criteria of

MyCol >= 13201000

will do it surely? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[r937]

ken, you probably meant to write

where mycol between 13201000 and 13201999

because 13202000 satisfies your inequality



rudy

 

[KenReay]

Hi

Well corrected

MyCol >= 13201000 AND <= 13201999

or as you say

where mycol between 13201000 and 13201999

would do it

but not LIKE, which is intenbded for string fields

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK