paul.hartland at fsmail.net
paul.hartland at fsmail.net
Tue Feb 17 02:56:44 CST 2004
The information is to appear in a datagrid, at the moment it is in seperate fields. But I want to call a sproc, to fill the datagrid and would like the address line to appear as one with commas Message date : Feb 16 2004, 07:07 PM >From : "David Emerson" To : "Access Developers discussion and problem solving" Copy to : Subject : Re: [AccessD] Concatenating Fields In SQL Stored Procedure Or SQL View Paul, Were do you want the information to appear (in a sproc, in a spreadsheet ?) How are you extracting the data at the moment? Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Churton Park Wellington, New Zealand Ph/Fax (877) 456-1205 At 16/02/2004, you wrote: >To all, > >I have a table in SQL Server 7.0 called tblClient with the following >fields of information: > BranchNo > BranchCode > ClientName > Addrs1 > Addrs2 > District > Town > County > Postcode > Telephone > >I want the following fields ClientName, Addrs1, Addrs2, District, Town, >County, Postcode to appear as one line separated by a comma like below > >BranchNo BranchCode Address >9999029 B&Q9999029 ClientName, Addrs1, District, Town, >Postcode > >As you can se from the example Addrs2 and County are missing, this is >because these are blank sometimes. I have tried a couple of ways but >always end up with the following > >BranchNo BranchCode Address >9999029 B&Q9999029 ClientName, Addrs1, , District, Town, , >Postcode > >As you can see where the missing fields are the comma’s still appear. Any >help on this will be gratefully received. > >Paul Hartland >Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month >www.freeserve.com/anytime >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime