Re: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
On 5/6/2012 12:21 AM, Rick Schummer wrote: Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? Not sure if you were referring to SQL Server or MySQL, but one of my all-time favorite Visual FoxPro Wiki entries: http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP Hey Rick, Yeah, I should have specified MySQL, not SQL Server. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4fa83184.6070...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
On 5/6/2012 12:21 AM, Rick Schummer wrote: Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? Not sure if you were referring to SQL Server or MySQL, but one of my all-time favorite Visual FoxPro Wiki entries: http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP Great link...thanks! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4fa83ff7.6000...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? Not sure if you were referring to SQL Server or MySQL, but one of my all-time favorite Visual FoxPro Wiki entries: http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005b01cd2b3f$afc304e0$0f490ea0$@whitelightcomputing.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
Hi Mike, It's Replace() SELECT REPLACE('The quick brown fox', ' ', '_') = The_quick_brown_fox Paul On 4 May 2012 15:53, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadwx0+jb+m7xrcwyqw3fb_zfbsyi0nr8mxd9caoh_ze6szg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
Replace() Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: 04 May 2012 15:53 To: ProFox Email List Subject: [NF] SQL equivalent for STRTRAN/CHRTRAN ? Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f11e0...@ex-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
and use Charindex() to search for an expression in another expression like AT() Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: 04 May 2012 15:53 To: ProFox Email List Subject: [NF] SQL equivalent for STRTRAN/CHRTRAN ? Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f11e0...@ex-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
...and I forgot also Patindex() to search for a string in another string remember positions relative to 0 not 1! Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 04 May 2012 16:32 To: ProFox Email List Subject: RE: [NF] SQL equivalent for STRTRAN/CHRTRAN ? and use Charindex() to search for an expression in another expression like AT() Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: 04 May 2012 15:53 To: ProFox Email List Subject: [NF] SQL equivalent for STRTRAN/CHRTRAN ? Is there a SQL equivalent function for replacing characters like we have in the STRTRAN/CHRTRAN functions? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f11e0...@ex-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
On 5/4/2012 11:33 AM, Dave Crozier wrote: ...and I forgot also Patindex() to search for a string in another string remember positions relative to 0 not 1! Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 04 May 2012 16:32 To: ProFox Email List Subject: RE: [NF] SQL equivalent for STRTRAN/CHRTRAN ? and use Charindex() to search for an expression in another expression like AT() Dave Thanks, Paul Dave! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4fa406f8.9050...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.