Select Query

[manu]

I've got a field with all kinds of data, e.g.

1235*285
10*258
1234567
89898750256

I need to select fields: without any special characters, where the field has 7 numeric characters as "1234567" above

All help is much appreciated.

regards,

 

[RV]

How bout this:

SELECT Table.TableField
FROM Table
WHERE IsNumeric(Table.TableField)=-1
AND Len(Table.TableField)=7;

where Table is <your tablename> and TableField is <your fieldname> ?

Suc6,

RV