topic Re: problem with select statement in Application Development and Automation Discussions

problem with select statement

former_member799868 — Tue, 07 Aug 2007 16:46:21 GMT

i want to select the some entries using one condition ie

select field1 field2 from table1 where field = 7*34 .

in place of * ay character like 1 ,2, 3 or a, b, c are there i.e for all values of * the record must be selected..

how can i code this.........

Former Member — Tue, 07 Aug 2007 16:51:15 GMT

I'm not sure to understand your requirement anyway you can use LIKE to do select with a string:

select field1 field2 from table1 where field LIKE '7%34' .

In this way all records with the first character of field FIELD is 7 and the two last chararcters are 34 will be selected.

Max

Former Member — Tue, 07 Aug 2007 16:58:48 GMT

Use in

where field <b>like '7%ab'</b> in ur where clause.

Thanks

Mahesh

Former Member — Tue, 07 Aug 2007 17:33:57 GMT

Check this

Select <Your fields>

from <Your table>

into <Your IT>

where field like '7%6'.

Regards

Gregory

Former Member — Tue, 07 Aug 2007 17:43:23 GMT

Try:


select field1 field2 from table1 where field like '7_34' .

Use the underscore "_" in place of any <u>single</u> character.

rob