| View previous topic :: View next topic |
| Author |
Message |
PattyDully
Newbie
Joined: 04 Jun 2012
Posts: 4
|
 Posted: Tue Jun 05, 2012 10:42 am Post subject: is there such a thing as endswith or startswith parameters |
 |
|
I have the switchboard made and is working well my issue is we stored the name as last name first then first name, the person I am working with didn't want two separate fields although it would have made my life easier. So is there a way I can tell the query that I want anything that has whatever the user inputs to be brought up. lets say they type "you" I want it to display Your yourself you etc. any ideas?
_________________
PDully |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Jun 06, 2012 10:02 am Post subject: |
|
|
SELECT * FROM "Persons" WHERE "Surname" LIKE 'Summer%'
SELECT * FROM "Persons" WHERE "Surname" LIKE '%man'
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
PattyDully
Newbie
Joined: 04 Jun 2012
Posts: 4
|
| Posted: Wed Jun 06, 2012 10:13 am Post subject: SQL statement |
|
|
That is fine if I want a static. Ithe Parameter that I currently put in is the name1 where Name is the actuall field... the statement you sent doesn't work it gives me an error.
Any other ideas
_________________
PDully |
|
| Back to top |
|
|
|
