Click here to Skip to main content
15,882,464 members
Home / Discussions / Database
   

Database

 
GeneralRe: Need help on table design Pin
astv25-Jun-07 8:58
astv25-Jun-07 8:58 
GeneralRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 9:34
Colin Angus Mackay25-Jun-07 9:34 
AnswerRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 9:45
Colin Angus Mackay25-Jun-07 9:45 
AnswerRe: Need help on table design Pin
astv25-Jun-07 10:25
astv25-Jun-07 10:25 
GeneralRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 11:18
Colin Angus Mackay25-Jun-07 11:18 
GeneralRe: Need help on table design Pin
astv25-Jun-07 11:34
astv25-Jun-07 11:34 
GeneralRe: Need help on table design Pin
Colin Angus Mackay26-Jun-07 0:04
Colin Angus Mackay26-Jun-07 0:04 
QuestionUsing the LIKE keyword in a query Pin
reegan4125-Jun-07 5:19
reegan4125-Jun-07 5:19 
Hey,

I'm using this database through MS Access with my program and I need to be able to use the LIKE keyword. My forms have specific, formatted field names that are sequential and uniform. Essentially, the first part of every form field name is a part of its subsequential heading.

IE.

I have a 'heading' column in my table, 'paragraphs'. One example of my headings is 'Scope of Services & Workplan/Methodology Overview'.

Now, if I were to use a query searching for that exact name everything works fine. However, I need to use the LIKE clause as follows:

SELECT heading FROM paragraphs WHERE heading LIKE 'Scope%'

This is because the first part of my form fields are the first words of every heading. ie. Scope_1_chbx, Scope_2_chbx, and so on.

My LIKE clause is resulting in the query returning no results....can anyone help me? Thanks.

---
reegan41
AnswerRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 8:47
Kschuler25-Jun-07 8:47 
GeneralRe: Using the LIKE keyword in a query Pin
reegan4125-Jun-07 8:51
reegan4125-Jun-07 8:51 
GeneralRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 9:01
Kschuler25-Jun-07 9:01 
QuestionSQL XML 3 BulkLoad Error Pin
Panchal Hardik25-Jun-07 2:28
Panchal Hardik25-Jun-07 2:28 
AnswerRe: SQL XML 3 BulkLoad Error Pin
Dave Kreskowiak25-Jun-07 4:05
mveDave Kreskowiak25-Jun-07 4:05 
QuestionSQL CE Query Performance Pin
Ferudun Atakan24-Jun-07 22:44
Ferudun Atakan24-Jun-07 22:44 
AnswerRe: SQL CE Query Performance Pin
andyharman24-Jun-07 23:12
professionalandyharman24-Jun-07 23:12 
QuestionSelect unique column??? Pin
Doan Quynh24-Jun-07 22:26
Doan Quynh24-Jun-07 22:26 
AnswerRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 22:31
Colin Angus Mackay24-Jun-07 22:31 
GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:49
Doan Quynh24-Jun-07 22:49 
GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:54
Doan Quynh24-Jun-07 22:54 
GeneralRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 23:50
Colin Angus Mackay24-Jun-07 23:50 
Questionyou tried to execute a query that doesn't include the specified expression Pin
nitin324-Jun-07 21:58
nitin324-Jun-07 21:58 
AnswerRe: you tried to execute a query that doesn't include the specified expression Pin
Krish - KP24-Jun-07 22:12
Krish - KP24-Jun-07 22:12 
Questionhelp Pin
nisha thakur24-Jun-07 21:11
nisha thakur24-Jun-07 21:11 
AnswerRe: help Pin
gauthee24-Jun-07 21:13
gauthee24-Jun-07 21:13 
QuestionQuery regarding connecting database Pin
John.L.Ponratnam24-Jun-07 21:03
John.L.Ponratnam24-Jun-07 21:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.