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 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/
