0

I need to merge 2 notes fields in a sql database This select script gets me what I need how do I merge notes into Technote, I have a function to filter out the characters in the phone number that's what the stripped is

Select db1.dbo.customer.cust_no, db1.dbo.customer.Phone_home, db1.dbo.customer.technote,db2.dbo.customers.notes from db2.dbo.customers
inner join db1.dbo.customer on  dbo.fnPhonePart('stripped', db2.dbo.customers.bhtel) = db1.dbo.customer.phone_home
2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by dickersonka
0

you can just use a '+' (plus sign) if they are two string fields

i added a space in between the fields as well

select db1.dbo.customer.technote + ' ' + db2.dbo.customers.notes as FULL_NOTE
--put the rest in here
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.