can any one tell me conversion functions in sql with examples plz?

Question

i am having troubls specially in TO_NUMBER to char function

Answer 1

TO_NUMBER: converts a character value expressing a number to a number datatype.

Syntax:
TO_NUMBER(char)

Example:
UPDATE SET salary = salary + TO_NUMBER(SUBSTR('$100',2,3));

Output:
10 rows updated.
____________________________________-
TO_CHAR: converts a value of a number datatype to a character datatype, using the optional format string. TO_CHAR() accepts a number(n) and a numeric format(fmt) in which the number has to appear. If fmt is omitted, 'n' is converted to a char value exactly long enough to hold all significant digits.

Syntax:
TO_CHAR (n[,fmt])

Example:
SELECT TO_CHAR(17145,'$099,999') "Char" FROM DUAL;

Output:
Char
- - - - - - - - - - - -
$017,145

[Look, I've given u the examples from my previously done queries, if u find any difficulty, u can mail me].

Answer 2

declare @numeric as int
declare @varchar as varchar(50)

set @numeric=23

--to convert number to varchar

select @varchar=
convert(varchar(50),@numeric)


-- to convert varchar to numeric need another step to validate the varchar


select @numeric=convert(int,@varchar)

Answer 3

declare @variable as int
set @variable = 5
SELECT CONVERT(char, @variable)
???
I am not to sure of your question