Thanks for that Larry
The database uses greek characters , which is whiy the NVARCHAR , but obviously this isnt required for an English post code Mike --- In [email protected], "Larry Manire" <[EMAIL PROTECTED]> wrote: > 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 --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EA3HyD/3MnJAA/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/
