Learn more about page titles
Reformatting formatted address fields

Last modified

Overview

This section explains how to reformat an address field.

Reformatting formatted address fields

In this example, the address field from the Meetings section in the application may have been formatted.  The pdf only allows for a single line of text.  The following listing shows how to remove any formatting from the relevant fields, adding back a comma where appropriate:

INSERT INTO @Data
SELECT 'MeetLoc',
        (SELECT MeetLoc = REPLACE(REPLACE(MeetingLocation, CHAR(13),''), CHAR(10),', ') 
                + ', ' + REPLACE(REPLACE(MeetingAddress, CHAR(13),''), CHAR(10),', ')
        FROM dbo.Meeting
        WHERE MeetingID = @MeetingID)
Page statistics
197 view(s) and 5 edit(s)
Social share
Share this page?

Tags

CCH Insolvency

Comments

You must to post a comment.

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |