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.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright