How to query the First 2 characters of count in adobe campaign?

[#1]

Hi,

I need to fetch or query first 2 characters of Zip code as count  from one table in adobe campaign.

Thanks & Regards,

jameel.sk

[#2]

Hi,

Amit_kumar thank you for replay to this post..

i tried the way u mentioned in post but i am getting error while executing the query.

please check once.. any one help on this issue.. why am getting error..

error.jpg ‏23 KB