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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:16:54
|
Sean (WebLeppard) writes "I shall bow before you if you can do this: Honest!!
Here is the scenario:
I have a search page that operates on SQL 7 with stored procedures. I have a table that has 7 fields - 2 of which are LastName and PromoNumber.
The wish here is to be able to enter either the Last Name of the person or the numeric Promo Number into the same search field named FieldName and bring their infomation to the page.
I have used isNumeric, Casting, Convert and the like. The page is currently set up to pull lastname and firstname. The boss doesn't want a new field, rather to enter the promo number into the lastname field. I tried to say IF(IsNumeric(LastName)) Then LastName = PromoNumber. (I don't have the exact syntax here now)
Any Ideas?
Thanks and good luck."
|
|
|
|
|
|
Numeric Field or Character field are one and the same.