Mike, Changing nvarchar to varchar will allow you to see the field.
Larry Manire -----Original Message----- From: Mike Singleton [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 5:31 AM To: [email protected] Subject: [Maptitude] Problem With SQL ODBC Just started with Maptitude and wish to add some external data based on postcode however when I add a table / view or query, only numeric fields show up in maptitude. Postcode is stored as NVARCHAR(8) Also tried a view which uses this SQL SELECT COUNT(*) AS NoPatients, LEFT(PatientPostCode, 4) AS PostCode FROM dbo.tblPatient WHERE (SiteCode = 'NCL') GROUP BY LEFT(PatientPostCode, 4) ORDER BY LEFT(PatientPostCode, 4) Thanks in advance Mike Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/TzSHvD/SOnJAA/79vVAA/C5grlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Maptitude/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
