topic Re: Cast shape number field to string in Data Management Questions https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660250#M37446 <HTML><HEAD></HEAD><BODY><SPAN>Understood, i'll do it the old fashion way with cursor..</SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 12 Jun 2012 03:15:50 GMT gilKrips 2012-06-12T03:15:50Z Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660248#M37444 <HTML><HEAD></HEAD><BODY><SPAN>Hi, i'm trying to cast a numeric field in a shapefile feature class to string.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>Any suggestions?</SPAN></BODY></HTML> Mon, 11 Jun 2012 17:05:26 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660248#M37444 gilKrips 2012-06-11T17:05:26Z Re: Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660249#M37445 <HTML><HEAD></HEAD><BODY><SPAN>Shapefiles aren't SQL entities -- they don't support a cast function (I don't think</SPAN><BR /><SPAN>file geodatabase supports casting either). For ArcSDE tables the exact syntax</SPAN><BR /><SPAN>would differ by RDBMS.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Mon, 11 Jun 2012 17:39:29 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660249#M37445 VinceAngelo 2012-06-11T17:39:29Z Re: Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660250#M37446 <HTML><HEAD></HEAD><BODY><SPAN>Understood, i'll do it the old fashion way with cursor..</SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 12 Jun 2012 03:15:50 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660250#M37446 gilKrips 2012-06-12T03:15:50Z Re: Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660251#M37447 <HTML><HEAD></HEAD><BODY><SPAN>File Geodatabase does support CAST.</SPAN></BODY></HTML> Mon, 18 Jun 2012 16:59:56 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660251#M37447 LanceShipman 2012-06-18T16:59:56Z Re: Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660252#M37448 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">File Geodatabase does support CAST.</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Yes i know that.. i just didn't knew how to cast shapes or if its even possible</SPAN><BR /><SPAN>I see now that its not so ill run on the features with a search cursor and search manually.</SPAN><BR /><SPAN>with sde, gdb and mdb i am good</SPAN><BR /><SPAN>thank you</SPAN></BODY></HTML> Mon, 18 Jun 2012 17:29:50 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660252#M37448 gilKrips 2012-06-18T17:29:50Z Re: Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660253#M37449 <HTML><HEAD></HEAD><BODY><SPAN>Found the answer in here</SPAN><BR /><A href="http://forums.esri.com/Thread.asp?c=159&amp;f=1707&amp;t=280410">http://forums.esri.com/Thread.asp?c=159&amp;f=1707&amp;t=280410</A></BODY></HTML> Sun, 12 Aug 2012 10:23:34 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660253#M37449 gilKrips 2012-08-12T10:23:34Z Re: Cast shape number field to string https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660254#M37450 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/migrated-users/289244">Michelle Mathias</A>‌ can you resurrect the thread that "gil Krips" found as I need to see the answer as it may solve my problem.</P></BODY></HTML> Tue, 17 Jul 2018 10:23:27 GMT https://community.esri.com/t5/data-management-questions/cast-shape-number-field-to-string/m-p/660254#M37450 DuncanHornby 2018-07-17T10:23:27Z