April 14, 2015 at 9:44 am
I need help with expression to create a schedule workflow. I want to update P.O. Box XXXX in [:CLAddress.Address2] with Post Office Box XXXX. Can someone help me?
April 14, 2015 at 9:47 am
Unless there's something I've missed, I think you just need to use the REPLACE function.
John
April 14, 2015 at 9:54 am
I can't use the search and replace function because it is part of a grid in clients, due to the fact that one client may have multiple addresses.
April 15, 2015 at 4:36 am
No, they meant for you to use the REPLACE function in a query.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2015 at 9:24 am
SELECT REPLACE(Address2,'P.O. Box','Post Office Box') AS Address2 FROM CLAddress
https://msdn.microsoft.com/en-CA/library/ms186862(v=sql.100).aspx
better yet...
https://msdn.microsoft.com/en-us/library/ms181984(v=sql.100).aspx
I realize you may not have known about the REPLACE function but the previous posters were trying to push you in the right direction. It's good homework to look at the second link and know what (T)SQL can do with strings.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply