>Hi John,
>
>You need to use LIKE and a wildcard.
>
>The where clause of your SPT might look something like:
>
where cChargeID like '99123001%'
>The wildcard stuff in SQL is pretty advanced - it approaches regular expression parsing. See the books on line for more details
>
>Cheers,
>
>Andrew
Thanks Andrew!
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright