Cast shape number field to string

Question

Hi, i'm trying to cast a numeric field in a shapefile feature class to string.
I tried writing "CAST("fid" as char(20)) like '%50%'" and expected it to return featues that the fid value contains the request digits but it does not seem to work.
Any suggestions?

D_Hornby_ddh_uni · Answer

Michelle Mathias‌ can you resurrect the thread that "gil Krips" found as I need to see the answer as it may solve my problem.

gilKrips · Answer

Found the answer in here
http://forums.esri.com/Thread.asp?c=159&f=1707&t=280410

gilKrips · Answer

File Geodatabase does support CAST.

Yes i know that.. i just didn't knew how to cast shapes or if its even possible
I see now that its not so ill run on the features with a search cursor and search manually.
with sde, gdb and mdb i am good
thank you