Gossamer Forum
Home : Products : DBMan SQL : Discussion :

SQL Question...

Quote Reply
SQL Question...
OK I need some help here. I don't know if I'm doing something wrong. In the flat file DBMan, on the search page I could type B* in a field like "Last Name" and get back all the "Last Name" starting with B. It doesn't seem to work the same way in DBManSQL. It returns ANY last name that has a B in it! I've tried B* B%, with and without Whole Word (WW). What's the deal here...what do I have to do?

I've had other users ask how to search for their Marine units like HMH-162. Some people put it in the database as HMH162 or HMH 162 or HMH-162. With htgrep, you could type HMH*162 and get back all 3 different ways in one list. For now, I had to tell them to do an individual search for each way.

Any help would most definetely be appreciated!

AJ

Subject Author Views Date
Thread SQL Question... TheFew 2921 Jun 28, 2000, 3:00 AM
Thread Re: SQL Question...
Stealth 2761 Jun 28, 2000, 9:54 PM
Thread Re: SQL Question...
Katana Man 2747 Jun 29, 2000, 9:53 PM
Post Re: SQL Question...
TheFew 2758 Jun 30, 2000, 1:30 AM