Use the ISNULL command.

SELECT ISNULL(streetsuffix, '')

that will replace any NULL streetsuffix with no space.

You will have to include the ISNULL with all columns SELECTed. (Unless they can't/don't have a NULL).

-SQLBill

Depends on what you really want to do. Can you give us examples?

It could end up that the best solution is to get the portion of the string without the...

The problem is that Street Number and ZIP are probably INTEGERS (INT).

When you use the + with INTs, that's not CONCATINATE. It means ADD.

So you need to CONVERT or CAST...

It doesn't matter if you are using Crystal Reports or something else. The basic issue still exists.

If you run a query that is expected to return a value and that...

Nope, not being a wisea$$. You just overlooked part of the script. Yes, the tables are MyOrders and MyItems - but and this is an important BUT...in the FROM line...

One issue with the SET NOCOUNT ON is described in the Question of the Day (QOD). I believe it was yesterday's (27th of July) QOD - it concerned a script...

First the really good news...you didn't lose the datafiles. That means you recovered all or most of the data.

The log file is used to apply committed changes to a full...

OOOPPPS ... I left out something important.

It should have been:

SELECT rowcnt

FROM sysindexes

WHERE id = (SELECT id

                  FROM sysobjects

                  WHERE name = 'yourtablename')

    AND indid < 2

I ran the above script against...

SQL Server has to count each and every row when you use COUNT(*). But the same data is kept elsewhere.

Test this:

SELECT rowcnt

FROM sysindexes

WHERE id = (SELECT id

                  FROM sysobjects

                  WHERE...

Last possibility that I can think of:

Have you tried reinstalling the 7.0 Client Tools? Maybe in a different location?

-SQLBill

Have you tried just starting the services directly (Right click on My Computer, select Manage, find Services and then start the appropriate services)?

Did the SQL Server 2000 install load a...

From BOL,

timestamp is a  data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping...

Go to the Books OnLine, use the Index tab and enter Currency. Then double click on Data Types under currency. Select the option Using Monetary Data.

Hope that helps you,

-SQLBill

BOL=Books OnLine=Microsoft...

Since you aren't aware of where the Domain Controller is, I figure you aren't the network SysAdmin. Get in touch with the sysadmin, tell them the account that SQL Server...

There is an option to EXPIRE backups. Check that to see if it is set incorrectly.

-SQLBill