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
>Being new to SQL Server, I could use a little guidance. We have an application that stores booking numbers plus a space and a sequence for each criminal charge. A typical number might be something like "99123001 1." If this person has three charges the last character will iterate to match the number of charges. I want to pull all charges with booking number of 99123001 using SPT. What is the correct SQL Server syntax to do this? If I run the query to evaluate as = or like it returns nothing? Only when I add the 1,2,3 etc. does it return data.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
