problem with select statement

[former_member799868]

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]

Hi

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]

Use in

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

Thanks

Mahesh

[Former Member]

Hi

Check this

Select <Your fields>

from <Your table>

into <Your IT>

where field like '7%6'.

Regards

Gregory

[Former Member]

Try:

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

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

rob