Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Null value

2 Posts 2 Posters 0 Views 1 Watching

I Offline
I Offline
Icarus123

wrote on last edited by

#1

Hi there. I want to know, if i am using an Select statement in SQL, and it should return a value, but returns Null, how do i set the null value to a '0'? Thanks
S 1 Reply Last reply

0
I Icarus123

Hi there. I want to know, if i am using an Select statement in SQL, and it should return a value, but returns Null, how do i set the null value to a '0'? Thanks
S Offline
S Offline
szukuro

wrote on last edited by

#2

SELECT ISNULL(fieldname, '0')
1 Reply Last reply

0

Log in to reply