OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

is there such a thing as endswith or startswith parameters

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
PattyDully
Newbie
Newbie


Joined: 04 Jun 2012
Posts: 4

PostPosted: Tue Jun 05, 2012 10:42 am    Post subject: is there such a thing as endswith or startswith parameters Reply with quote

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
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Jun 06, 2012 10:02 am    Post subject: Reply with quote

SELECT * FROM "Persons" WHERE "Surname" LIKE 'Summer%'
SELECT * FROM "Persons" WHERE "Surname" LIKE '%man'
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
PattyDully
Newbie
Newbie


Joined: 04 Jun 2012
Posts: 4

PostPosted: Wed Jun 06, 2012 10:13 am    Post subject: SQL statement Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group