Load where field starts with...

[Anonymous]

Hi any help with the syntax base on the where clause beased on the idea below

load,

a

b

c

SQL SELECT *

FROM xxx;

where field b starts which all records beginning with the numeric  ' 000';

and

filed b contain 0000009,00000009,AAA003452,XXX0643

[nicolett_yuri]

try this

SQL SELECT *

FROM xxx;

where

WILDMATCH(b, '000*', '0000009','00000009','AAA003452','XXX0643')>0;

[manideep78]

Hi Try this,

LOAD

a,b,c

SQL Select * FROM XXX

WHERE NOT(b LIKE '000*');

[Anonymous]

I intended for this rather, where b is not like :

"where field b doesnot starts with ' 000';"  essentially i would want this as the resultant eg.

AAA003452

XXX0643

[Anonymous]

Am I missing something ???

[manideep78]

Use this

WHERE NOT(acno LIKE '000*');

[Anonymous]

Okay the acro field either numeric or alpha numeric records, Now how do i distinguish the two when loading???

[Anonymous]

Hi Guys,

where not left(acno, 1) ='0'; working fine as i can sort out the numeric from the alpha numeric records

Thanks