Results 1 to 2 of 2

Thread: Conversions

  1. #1
    Join Date
    Dec 1969

    Default Conversions

    I am retreiving a Value from TableA which is a Text Datatype (value is 3498) and i need to convert this value as a Number Datatype and insert into TableB. How can i convert a Value from Text to Number?

  2. #2
    Join Date
    Dec 1969

    Default RE: Conversions

    All you gotta do, right, is use the CONVERT statement in SQL, innit.<BR><BR>Let me give you an example, me old china.<BR>***<BR>DECLARE @my_lucky_number char(1)<BR>SET @my_lucky_number = "7"<BR><BR>SELECT CONVERT(integer, @my_lucky_number) AS MyLuckyInteger<BR>***<BR><BR>Easy-peasy, lemon-squeezy, innit?<BR><BR>Anyone wanna buy a used motor? One careful female owner, hones.<BR><BR>

Posting Permissions

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