Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
string concatenation
0 views
Skip to first unread message
ken
Apr 23, 2003, 1:53:51 PM4/23/03
to
I am trying to insert a text string into a table column.
This string is concatenated from 2 source strings,
eg. "John's" and "Website" ,
the problem is the 's. When the strings concat together
and pass to the insert sql statement, it generates an
error... because " ' " is read as the open/close quote
within the text, not an 's.
please help.... any way to include 's in the string???
This string is concatenated from 2 source strings,
eg. "John's" and "Website" ,
the problem is the 's. When the strings concat together
and pass to the insert sql statement, it generates an
error... because " ' " is read as the open/close quote
within the text, not an 's.
please help.... any way to include 's in the string???
Thanks.
Jeff Boyce
Apr 23, 2003, 9:14:44 PM4/23/03
to
Ken
Why? (as in "why are you making a copy of data you already have and storing
it?") Unless there's a business need, you could just "calculate" the
concatenated string when you need it (e.g., for a form or a report).
Typically, this would be done in a query, creating a new (query) field
something like:
FullName: [FirstName] & " " & [LastName]
Good luck!
Jeff Boyce
<Access MVP>
0 new messages