Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jitudavda
Starting Member
11 Posts |
 Posted - 2001-07-05 : 03:33:53
|
HiI'm facing problem in my searchSelect * from products where ProductID like '##P3%' Event I tried following statementSelect * from products where ProductID='##P3%' My output requirement is the list of all the product details which are exact or having last initial id as the supplied productID.I mean if I supplied ##P3 I require all the products which has productid =##P3 or ##P32 or ##P3A4At Present I'm getting error sometime and some time no resultsI think the problem may be '#'do anyone has suggestions.ThanksJitu |
|
|
|
|
|
Searching Charachter ## In Database