CONVERT function 1

[gojohnnygogogogo]

Hello,
How can I convert or cast a text field to a number field ?

I have tried things like :

SELECT CONVERT(number,PE) AS PEnumber

what is it ?


cheers.

 

[bdmclennan]

Give these a crack,
SELECT Clng(PE) AS PEnumber 'Converts to long
SELECT Cdbl(Pe) AS PEnumber 'Converts to double
SELECT Cint(PE) AS PEnumber 'Converts to integer


Cheers