Hi,
I have a different problem. I couldn't get any clue on how to handle it.
I need to generate a query whose where clause string not fixed.
I.e. there is no key column and it should be generated by entering from user.
SELECT col1, col2, col3, col4 FROM tab1
WHERE col6 LIKE "SD*" & "200" OR LIKE "SO*" & "095" OR LIKE "PD*" & "124"
The actual col6 data is as follows_
SD 200
PD201
SO 067
SD038
.......
Here in the code "200", "095" and "124" are vaibale not fixed and "SD", "SO" and "PD" are fixed.
How can I prepare this query?