query analyzer result set

hi,
Can I replace NULL to a blank in Query Analyzer Result Set ?

Thanks.

[lanWay]

±zŠn:
§A¥i¥HšÏ¥Îisnull(yourfield,' ')šçŒÆšÓ³B²z
<none> Œ¶Œg©ó¶l¥ó·s»D:***@TK2MSFTNGP04.phx.gbl...
hi,
Can I replace NULL to a blank in Query Analyzer Result Set ?

Thanks.

hi,
ÁÂÁ§AªºŠ^µª,SQL SCRIPT§ÚªŸ¹D¬O¥i¥H¥ÎISNULL©ÎªÌCOALESCEšÓÂàŽ«ªº.
§Ú¬O·Q°ÝŠbQuery Analyzer Result Set €€¬O§_Š³OPTION ¥i¥H±NNULL ªºÄæŠìµ²ªG €£­nÅã¥ÜNULL


"lanWay" <***@hotmail.com> Œ¶Œg©ó¶l¥ó·s»D:%233JFG$***@TK2MSFTNGP05.phx.gbl...
±zŠn:
§A¥i¥HšÏ¥Îisnull(yourfield,' ')šçŒÆšÓ³B²z
<none> Œ¶Œg©ó¶l¥ó·s»D:***@TK2MSFTNGP04.phx.gbl...
hi,
Can I replace NULL to a blank in Query Analyzer Result Set ?

Thanks.

[RM]

Not as I know.

hi,
謝謝你的回答,SQL SCRIPT我知道是可以用ISNULL或者COALESCE來轉換的.
我是想問在Query Analyzer Result Set 中是否有OPTION 可以將NULL 的欄位結果 不要顯示NULL
你可以使用isnull(yourfield,' ')函數來處理
hi,
Can I replace NULL to a blank in Query Analyzer Result Set ?
Thanks.