|
||||||
 |
|
|
LinkBack (1) | Thread Tools | Search this Thread | Rate Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack (1) | Thread Tools | Search this Thread | Rate Thread |
12-01-2006, 02:10 PM
|
|||
|
|||
Oracle dialect question:
selecting a record based on a persons name?if a person has got a first name middle name and a last name i want to be able to retrive that record by entering just his first and last name.
Note that there is only one column in the table in which all the names are stored.     
|
|
12-12-2006, 12:00 AM
|
|||
|
|||
ANY answer.
Re: selecting a record based on a persons name?
SELECT * FROM names WHERE name LIKE 'Jo% Bloggs'Not an exact solution (would also return Joseph Bloggs) but good enough for most name lookup screens. It simply ensures the name starts with Jo and ends with Bloggs.
|
|
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
LinkBacks (?)
LinkBack to this Thread: http://www.sqlrecipes.com/sql_questions_answers/selecting_record_based_persons_name-76/
|
|||
| Posted By | For | Type | Date |
| summermama's bookmarks on del.icio.us | This thread | Refback | 05-14-2007 06:44 PM |
