[dba-SQLServer] number manipulation

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jul 30 07:31:33 CDT 2003


On 7 Apr 2002 at 14:57, Peter Kaufman wrote:

> Hi Alan,
>  
> I don’t want an implicit conversion to string. Will right() work on a
> numeric value?
>  
> Do you know the MS SQL equivalent to Access’s int() function?
>  

myVariable - FLOOR(myVariable)


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.





More information about the dba-SQLServer mailing list