function

Good Morning,
I have a question.
Is there a function like ISNULL but for the space value(example ISSPACE)?

THANKSHi

There is no space function but you can compare directly or something like

RTRIM(<fld>) = ''

RTRIM can be affected by the version or compatibility level of SQL Server
you are using.

The SPACE(n) function will create a string of n spaces.

For all available string functions check out books online or
http://msdn.microsoft.com/library/d..._fa-fz_7oqb.asp

John

"Killer" <roninkaiser@.tiscali.it> wrote in message
news:hFBxc.99850$Qc.3858785@.twister1.libero.it...
> Good Morning,
> I have a question.
> Is there a function like ISNULL but for the space value(example ISSPACE)?
> THANKS|||"Killer" <roninkaiser@.tiscali.it> wrote in message news:<hFBxc.99850$Qc.3858785@.twister1.libero.it>...
> Good Morning,
> I have a question.
> Is there a function like ISNULL but for the space value(example ISSPACE)?
> THANKS

It looks like you got an answer in another group - please do not post
to multiple groups independently.

Simon