load a single column from table

[#1]

Hi friends

I want to load single column from table without excluding any column....

here I want to load Id column and value of id should be start with 'GN' only can anyone please tell me how is it

[alexandros17]

Load * resident myTable where Left(ID,2)='GN';

let me know

[MarcoWedel · Accepted solution]

LOAD ID FROM yourtable

Where ID like 'GN*';

[#4]

LOAD ID FROM table

Where ID like 'GN*'