Information générale
Catégorie:
Codage, syntaxe et commandes
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.....
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement