it will return the integer value of a variable for example intval(42)

What is INTVAL( )and where we use

Plz any body help me

Question Posted / akash

Answer Posted / akash

it will return the integer value of a variable

for example

intval(42); // 42
intval(4.2); // 4
intval('42'); // 42
intval('+42'); // 42

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to replace null values in expressions using isnull()?

1049

What is mscorsvw.exe - process - microsoft .net framework ngen?

899

Can the query output be sorted by multiple columns in ms sql server?

932

Can a rule be bound to any column of any data type?

908

what is a self join? : Sql server database administration

959

what is the sql equivaent of the dataset relation object ?

1959

What is the difference between ddl,dml and dcl commands?

1056

What is the use of toad or sqldbx.?

1097

what do you understand by change data capture?

934

How to assign null values to variables or columns?

907

User wants only to display only pdf as export option in report manager. How to achieve this?

247

between cast and convert which function would you prefer and why?

915

Do you know what is fill factor and pad index?

940

Do you know the isolation level that sql server support?

920

What are the mathematical functions supported by sql server 2005?

993