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,

I am getting error while query running in the way you shared screen shot i followed i write query the query saved but when i try to run the query i am geeting error the query will became red and process will be stoped.