Thread: Val function in T-SQL in microsoft.public.sqlserver.programming

  Dear Russell and ewm Thank you for your advice, it does work! Amos Sobel "Russell Fields" wrote: > Look at the CAST function. e.g. > > CAST ('12345' AS INT) > > RLF > > "Amos Sobel" <AmosSobel@discussions.microsoft.com> wrote in message > news:7DF408BC-7C09-475B-A582-F2A2D397B780@microsoft.com... > >...

  Look at the CAST function. e.g. CAST ('12345' AS INT) RLF "Amos Sobel" <AmosSobel@discussions.microsoft.com> wrote in message news:7DF408BC-7C09-475B-A582-F2A2D397B780@microsoft.com... > Dear Friends > > I am trying to convert code from MS ACCESS to SQL 2005 VIEW (T-SQL ?). I > miss the function which convert a string of digits to a number. In MS > ACCESS...

  The answer is in your question. Take a look at the CONVERT function. "Amos Sobel" wrote: > Dear Friends > > I am trying to convert code from MS ACCESS to SQL 2005 VIEW (T-SQL ?). I > miss the function which convert a string of digits to a number. In MS ACCESS > it is VAL. I could not find it in T-SQL. > > Your help is very welcome. > > Amos Sobel...