Results 1 to 2 of 2

Thread: SQL data Convertion

  1. Dec 2nd, 2004, 06:20 AM #1
    mahivr
    mahivr is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2004
    Location
    india
    Posts
    95

    SQL data Convertion

    hi,

    im using sql server as my backend and one filed has 00-1 (varchar) and want to conver to -1 (decimal).

    how shd i implement this in SQL statement.
    Reply With Quote Reply With Quote
  2. Dec 2nd, 2004, 08:38 AM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Take a look at the CAST and CONVERT functions in SQL Server...

    Code:
    SELECT CAST(MyTableCol AS decimal(10,5))

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width