topic conversion of an integer to string in SQL query in Geoprocessing Questions

conversion of an integer to string in SQL query

MattFrancis — Tue, 25 Sep 2012 13:55:46 GMT

Hey All,

I am joining a table to my SQL database, and trying to determine if two values are equal, but I am having a hard time with this comparison

database.testing.PARCELS.PID <> PARCELS_SpatialJoin1.PID

The first value is text, the second is an integer. In the Select By Attributes dialog box, how do I make this work?

Re: conversion of an integer to string in SQL query

ShaunLam — Tue, 25 Sep 2012 21:57:55 GMT

Create a new field as Text, field calculate that field as the integer field. Re run the select by attributes with the 2 text fields.

Re: conversion of an integer to string in SQL query

FabianBlau — Sat, 11 Dec 2021 14:58:22 GMT

These sites will probably help:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000033000000
http://msdn.microsoft.com/en-us/library/aa226054%28SQL.80%29.aspx

So try (the parameter for varchar is the size of your text-field, maybe 50):

database.testing.PARCELS.PID <> CAST(PARCELS_SpatialJoin1.PID AS varchar(50))