Bull shit.

Sorry, but I cannot find more adequate definition.

'5 spaces' = ''

Is it so difficult to test it?

DECLARE @A char(5), @b-2 varchar(5)

SET @A = ''

SET @b-2 = ''

SELECT DATALENGTH(@A), DATALENGTH(@B)

WHERE @A = @b-2

DATALENGTH shows you real number of...

So do we have anything that's faster than RTRIM(ERR)>''?

Did you read my last post&

WHERE Err>''

is all you need.

declare @ERR char(20)

set @ERR = '  '

select 1

where @ERR > ''

select 1

where len(@ERR) > 0

It does not return anything. No matter that @ERR has actually 20 spaces inside.

noeld,

when LEN(Err) = 0 there are no beginning spaces.

All spaces are trailing.

Otherwise LEN gonna be > 0

In this task we don't care about not empty strings, string is not empty...

They do.

And you can see it using function "datalength".

But LEN ignores trailing spaces.

Try it first, than say.

Proper call:

<Server>.<Database>.<Owner>.<Object>

LEN(RTRIM(LTRIM(ERR))) > 0

is equal to

LEN(ERR) > 0

Can you describe desired result in words?

What's a logic behind it?

So, show it.

Where is order of your codes defined?

From the example you displayed it's not possible to say if B is following E or E is following B.

Lester,

despite you have "=" between quotes, you have "+" outside the quotes, and this is operator as well.

Than, there is no datatype varchar...

1st - you cannot use any operation within PRINT command.

Construction like

PRINT 'Number of rows='+ CAST(@intRows as varchar)

just not allowed.

declare @string

SELECT @string =  'Number of rows='+ CAST(@intRows as varchar(10)...

Just guess:

do you actually use something like  PRINT ... + CAST(... as varchar(10)) ?