Gianni, Rafael
I would definitely recommend the VFPSQL - TSQL - Mapping article. I have found it very useful in the past.
Paul Newton
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Gianni Turri Sent: 02 May 2019 23:53 To: profoxtech@leafe.com Subject: [SUSPECTED SPAM] Re: TSQL equivalent of strtran function
Sent by an external sender ------------------------------
Hi Rafael,
should be this:
REPLACE (Transact-SQL) https://docs.microsoft.com/en-us/sql/t-sql/functions/replace-transact-sql?vi...
VFPSQL - TSQL - Mapping http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
Gianni
On Thu, 2 May 2019 19:40:40 -0300, Rafael Copquin rafael.copquin@gmail.com wrote:
Please tell what function in TSQL can I use in the same way as STRTRAN in VFP
I ned to remove the point from a character expression such as
12345.67 to leave as 1234567 in TSQL
TIA Rafael Copquin
[excessive quoting removed by server]