Joe ---
I used to work with these codes (CPT, HCFA stuff, et al)....the best thing to do is to store them with leading zeros...that seems to be acceptable in claims processing systems which is what you're working on if dealing with CPT codes.
>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.....
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05