function

[Killer]

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

THANKS

[John Bell]

Re: function

Hi

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/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_7oqb.asp

John

"Killer" <roninkaiser@ti scali.it> wrote in message
news:hFBxc.9985 0$Qc.3858785@tw ister1.libero.i t...[color=blue]
> Good Morning,
> I have a question.
> Is there a function like ISNULL but for the space value(example ISSPACE)?
>
> THANKS
>
>[/color]

[Simon Hayes]

Re: function

"Killer" <roninkaiser@ti scali.it> wrote in message news:<hFBxc.998 50$Qc.3858785@t wister1.libero. it>...[color=blue]
> Good Morning,
> I have a question.
> Is there a function like ISNULL but for the space value(example ISSPACE)?
>
> THANKS[/color]

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

Simon