Joe,

I work with CPT codes also. You can't define fields like this as numeric because you never know when they (the CPT gods) will add alphas to the codes, and besides, somebody else defined the tables which I use.

Try BETWEEN(PADL(ALLT(MyCPTCode), 5, ' '), MyFirstCPTCode, MySecondCPTCode)

Cindy

>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.....