Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nimesh69
Starting Member
30 Posts |
 Posted - 2000-12-17 : 07:17:30
|
| Hi All,I've developed app with ASP/COM/SQL7.0Due to the inconsistency in the development standards some of my developers have coded such that while saving to DB some nullable column gets saved as NULL where as some as spaces.I'm facing typical problem now i.e. In asp we do encode/decode to allow user to enter lt/gt (<>) characters, if encode/decode encounters NULL, it abandons the further ASP processing without giving any error. just as "response.end"The only way i'm aware of is, change all the save function to save space in the database for all nullable column OR in the ASP check for NULL, if value is NULL then don't encode/decode.I don't have that much of time to change all ASP/stored procs to incorporate above change as i have a critical deliverable scheduled early next week.Hence, i'm seeking for simpler sol.If anybody is aware of any SET(or any other) command in SQL 7.0 which will return spaces if a column contains NULL.Many thanks,- Nimesh |
|
|
|
|
|
Null to Spaces in SQL 7.0