make integer

[piti]

hi

i'm using this code in my select query

concat(value/1000, ' some text'),

how should i edit the query to make it return only integer values from "value/1000" - something like cast statement

thanx

 

[devnull22]

try this :

SELECT CONCAT(ROUND(value/1000,0),'some text');

just off the top of my head


cheers devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !