WHERE clause problem in script

[#1]

I have a field called ItemCode. I only want to load all items starting with 'F'.

I have problems writing the script to only load these fields. I currently have this script:

LOAD

upper(ItemCode) as ItemCode,

upper(WhsCode) as WhsCode,

OnHand

FROM H:\QvData\DOS\OITW.qvd(qvd)

WHERE ItemCode=('F*');

[#2 · Accepted solution]

please put this condition

Where upper(left(ITEMCODE,1))='F'

Regards

Ashish Srivastava

[#3]

Thanks for the help. This worked perfectly.