Jonathan, as usual, in on the ball here. His solution is the answer to your question (I overlooked the word sum doh )....

First look indicates that you have not specified how to join systemDataTest and res_test which will result in a cartesian join. Can you post table ddl.

Do you mean this

SELECT 'this string' + ' ' + 'has been concatenated'

or with variables

DECLARE @string1 varchar(30),@string2 varchar(30)

SET @string1 = 'this string'

SET @string2 = 'has been concatenated'...

SELECT RIGHT(colname,CHARINDEX(CHAR(13),REVERSE(colname))-1)

FROM

If the function is working with a predefined string but not from your table then the problem must be with the data not conforming to the rules of the function.

As...

noeld, good stuff.

I implemented a staff database where a person only had only one internal, external, mobile number but could belong to more than one dept, report to more than one...

Is that so you can ignore mine

I still agree with Antares.

Enterprise Manager is definately not correct but then so is SERVERPROPERTY as this does not work on SQL7 and therefore to use it you must know...

This would do away with dynamic sql.

SELECT f.Name,

(CASE WHEN @language = 'English'

THEN t.English ELSE t.Spanish END) as 'Type',

f.Address1,

f.Address2,

f.City,

f.State,

f.ZIP,

f.Country,

f.Phone,

f.Fax,

f.WebSite

FROM...

It should be noted that SERVERPROPERTY is SQL2K only. The question only specified 'version number of your SQL Servers' not specific versions. Therefore, this question when applied to me (SQL7...

You can if you use TRANSACTIONS

This may help for the future. When doing deletes that involve joins I first create a select query (using the table to delete from as the main table) to check...

Hi Frank,

Yeh

Long time no conversation Frank

No nice emoticons

But you can still type the text equivalent

eg <colon>O <colon>sick<colon> <semicolon><rightbracket>