Ok, since the data is a string in SQL Server, I had to RTRIM before I used a ToInt64
for example: ToInt64(RTRIM(COLOUR)) And the COLOUR had to be in DECIMAL (429490176) for this to work. I will have to convert the Hex to Decimal before posting into SQL. Thanks for the help! -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Choosing-Column-for-Colour-tp6953634p6957507.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
