I'll try it in the mornin.. I'll look up Val Iguess it an absolute value or
something.
________________________
________
>WHERE BETWEEN(VAL(mytable.svccod, 22041, 66745))
>
>BTW, "m.svccod" is a memory variable and not a table field.
>
>Vlad
>
>>This is easy but I can't figure it out. (I ain't braggin or complainin).
>>I got a service code field (CPT codesfor HMO) it is 6char long
>>the codes are 5 or 3 in char like 44309 or 657,
>>I use a "where m.svccod between "22041" and "66745" statement in a query. My result is like
>>22049
>>22051
>>221
>>223
>>33452
>>33487
>>40078
>>403
>>404
>>etc etc
>>
>>How can I make this query output only 5 digit results like I asked
>>for in the between statement??
>>
>>Caught "between" a clock and a smart face.....