Have you tried the ANSI syntax in Sybase?

/Kenneth

It does indeed look like a network/connectivity error, though sometimes these messages can be a bit fuzzy and misleading.

Have you looked in the SQL Server log and the Eventlog for...

You can specify a casesensitive collation for each element in the replace, that way the replace will be casesensitive.

select replace('A' collate Latin1_General_CS_AS, 'a' collate Latin1_General_CS_AS, 'a' collate Latin1_General_CS_AS)

                  ...

Can you explain a bit about your purpose and intentions here?

If you update 5 rows in one update statement, there is no logical ordering - all 5 rows are logically...

YAW alternative (Yet Another Way)

-- If assumption is to check for existance first

IF OBJECT_ID('dbo.myTable') IS NOT NULL AND OBJECTPROPERTY(OBJECT_ID('dbo.myTable'), 'IsTable') = 1

-- If assumption is to...

You're in some troubles here due to the inconsistent formats of dates. There's no do-it-all formula for catching all kinds of possible dateformats in one go, and especially not to...

Yes, as discovered, if the user enters mutliple words, the words has to be in the same order in the text row searched as the user has entered them.

On...

Agreed, postions is a problem - didn't think of that. However, that should be solvable wihtout resorting to dynamic SQL nevertheless. You should be able write a function for that...

You may not want to use dynamic SQL for this purpose. There's absolutely no reason at all to use dynamic SQL in this case! Dynamic SQL is NOT the answer...

Well, try again.

I just copied the post and pasted into QA, and it ran with no problems. You realize that it's demonstrational, you must adapt it to your own tables.

/Kenneth

One method may be to use REPLACE and replace each space with the '%' wildcard.

create table #x ( word varchar(40) not null )

insert #x select 'monitors'

insert #x...

Of course, Itzik made one for that too.

if object_id('dbo.fn_dectobase') is not null drop function dbo.fn_dectobase

go

create function dbo.fn_dectobase(@val as bigint, @base as...

Great, almost there.

You need to supply a few rows of data for each table that demonstrates the problem you're having, and a display of your desired output from those sample...

Post DDL for tables involved, along with a few sample rows of data for each table and your desired output.

Provide it in 'script' form so that it is easy to...

..and what does 'limit' do in mySQL..?

/Kenneth