SQL functions

Results 1 to 2 of 2

Thread: SQL functions

  1. #1
    Join Date
    Dec 1969

    Default SQL functions

    I need some SQL functions to perform a particular query. I checked in my &#039;SQL unleashed&#039; book and the functions i needed were there : substr() and to_number(). But it seems that both are not recognized function names. So i checked again in my book to see that the substr function was not SQL-89 and SQL-92 standards and that it could have a different syntax if provided by a different vendor.<BR><BR> So i tried substring instead, which worked, but i havnt found the to_number equivalent already. Does someone knows what it is ? On SQL server 7.

  2. #2
    Medieval Dude Guest

    Default Lookup the CONVERT function. <eop>


Posting Permissions

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