missing operator error comes whats the problem...

[sivaulagu]

SELECT TXT_PART_DESCRIPTION,TXT_PART_ID, NewLastName: Left([TXT_PART_ID],1) from tbl_PART_ID

[recyan]

Have you tried :

SELECT TXT_PART_DESCRIPTION,TXT_PART_ID, Left([TXT_PART_ID],1) AS NewLastName from tbl_PART_ID

Thanks

[sivaulagu]

gr8 yaar thanks...a lot it works... simple one but o forgot

[sivaulagu]

if i need to take values from different table then???

[recyan]

simple one but o forgot

Happens to all of us.

Thanks

Edit :

if i need to take values from different table then???

Could not understand. Can you elaborate ?