3 May
2019
3 May
'19
9:42 a.m.
select replace('12345.67', '.', '');
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Thu, 2 May 2019, at 11:41 PM, Rafael Copquin 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
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]