...if there is no data after the 'F' on each row (we can only hope it is that easy).

I agree with you there, G. I noticed the last 3 words were the 'from', and it wasn't the same table as the one in the table DDL. ...

That view DDL does not reference the table DDL that was provided. Is this important?

Something else to think about...

What if your name is like: 'Smith, JeffF' ?

Anyway to get rid of the 'F' as a delimiter, perhaps use some other character?

Mark Harley (3/3/2008)

---

The report displays several records at a time, depending on how many are returned. The actual report is formatted like the following:

OrderNumber

Detail1

...

Does your report display the data in columns, several records at a time, or is each report page a single record?

update tf

set tf.transID = pr.attemptID

from prattempts pr, [servername].[databasename].[dbo].[tablename] tf

where pr.ID =...

Update [tablename]

set [columnnameA] = yourdata,

[columnnameB] = moredata

where [primarykeycolumn] =...

JSAD (3/3/2008)

---

update tf

set ID = pr.attemptID

from prattempts pr, [i]servername[/i].[databasename].[dbo].[tablename] tf

where pr.ID = tf.ID

This is the Logic

There are three tables(abbreviating it so tht i do not give out specific info)

1]...

You show a column 'custid' in your post. Do you have another table that contains 'Customer' data and 'custid'?

Steve Jones - Editor (3/2/2008)

---

...

Ex 3.

select

a.name

, b.address

, b.city

, b.state

, a.phone

, c.country

from customers a

inner join address b

...

It will also depend on how you want to use the records that contains nulls.

If TravelCost = null is the same as having TravelCost = 0, then you can use...

Scott,

This isn't what you were asking about, but...

Although this topic is almost a year old (at this writing), I'll throw in one of my pet peeves...

Don't abbreviate anything by omitting one or two letters.

Emplyee for Employee

Addrss for...

In Crystal, you have control of the display field format and can set the $ not to display. I personally don't like a column of 50 numbers each with...