pakai fungsi STR Returns character data converted from numeric data. Syntax STR ( float_expression [ , length [ , decimal ] ] )
----- Original Message ---- From: David Gunawan Sugianto <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, May 7, 2007 7:26:04 AM Subject: RE: [indoprog-vb] Tanya Function SQL Server? Thx responnya mas Aries. Cast dan Convert itu kan buat konversi dari NUMERIC ke STRING. Tapi yang saya inginkan kebalikannya, dari VARCHAR ke NUMBERIC. Thx. -----Original Message----- From: indoprog-vb@ yahoogroups. com [mailto:indoprog-vb@ yahoogroups. com] On Behalf Of aries Sent: 06 Mei 2007 7:33 To: indoprog-vb@ yahoogroups. com Subject: Re: [indoprog-vb] Tanya Function SQL Server? bisa pake CAST atau CONVERT ex. SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales FROM titles WHERE CAST(ytd_sales AS char(20)) LIKE '3%' SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales FROM titles WHERE CONVERT(char( 20), ytd_sales) LIKE '3%' David Gunawan Sugianto <[EMAIL PROTECTED] <mailto:dave- g%40sby.centrin. net.id> net.id> wrote: Apa function untuk konversi dari string menjadi numeric ya ? Thx. [Non-text portions of this message have been removed] ------------ --------- --------- --- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed]
