Skip to Content
0

If condition to return integer if true and strong if false

Dec 10, 2017 at 12:18 PM

25

avatar image
Former Member

Hello All, In 1 column I have 10,20, Quote. I declared column as nvatchar. Now I wanted to create a calculated column where if it’s no. I need to multiply by 10 else return string.

The output of calculated if statement should be:

100,

200,

Quote

I tried if statement and did not work.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers