Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If Field Is Null replace with with characters

Status
Not open for further replies.
jestrada101

jestrada101

Technical User
Mar 28, 2003
332
I have a script that select's data.

There is a certain field that at times has "NULL" values. If it's NULL, I want to put "NA" in that field... how can I do this?

Thanks!
JE
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
865
carp
carp
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top