![]() |
| |||||||
![]() | « Previous Thread | Next Thread » |
| | LinkBack | Thread Tools | Display Modes |
| |||
| Hi, I have a table the design is like this Id Description I want to find out if the tables description field has any values that start with Sem-Conf And if so then display all the values that start with Sem-Conf So say for example it will hold values like this Sem-Conf Discussion making for kids Sem-Conf Teach kids about maths So when i display the values i only want to display Discussion making for kids Teach kids about maths I tried the % in sql but it didnt work any idea todd |
| Sponsored Links |
| ||||
| As I responded in the other forum about your database, you have an underlying flaw in the design of your table. It violates First Normal Form, in that you are coding more than one piece of data in the same field. In a properly designed table, every data field should be "atomic"--a single indivisible value. Then you wouldn't be having this problem. |
![]() |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| retrieve values | todd2006 | SQL Development | 5 | June 19th, 2008 01:46 PM |
| Store Calculated Values (Updating Fields) | sbenj69 | Microsoft Access | 6 | May 26th, 2008 10:18 AM |
| Finding Datalist Row on auto postback | richyrich | .Net Development | 1 | May 12th, 2008 04:52 AM |
| Sponsored Links |
| ASP.NET Resource Index a directory of ASP.NET tutorials, applications, scripts, assemblies and articles for the novice to professional developer. Free Web Directory Including Chats and Forums Resources, Offer automatic, instant and free directory submissions. | URLZ Web Directory URLZ Web Directory Free Web Directory - Add Your Link The Little Web Directory | Free Web Directory Pegasus free web directory is a free directory organised by categories. Web Directory & SEO Services dirroot web directory |