Re: TSQL equivalent of strtran function

What is the data type for that column? Char, VarChar, NVarchar? Or is it numeric and you are pulling the data in a select and you do not want the decimal point to show?

On Thu, May 2, 2019 at 5:41 PM 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

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

---

[excessive quoting removed by server]