Added information: the datatype of the zip code field in the SQL table is nvarchar(15), null.

Just need to get the correct zip code with 0 as first digit imported into...

Lowell-

Thanks! This is exactly what I needed and now can understand the full logic and script.

Thanks again.

G-Squared:

Your script works and pretty much does what I need. Can you explain exactly what this script is actually doing?

Sorry but still learning the basics of SQL and not entirely...

Elliot:

Thanks for the information. Yes this worked!

So simple but I could not find this even after looking for almost an hour.

Thanks again - you saved me a lot of grief

The final result should be:

"018246" "LASER DIODE-RED,30MW,655NM,5.6MM D OBS"

with no extra quotes around OBS part of string as in this example.

Still having problems with getting correct output data extract file. SQL script is pulling item.item and item.description from item table

and putting double quotes around each string - this is...

The results from SQL query/script are to a file and or text.

I forgot to add an important piece of information. We do not want to update or fix the data within the SQL table, we do want to fix the data...

Thanks Flo and Bob:

The Collate statement allowed me to find the incorrect string and the Update query allowed me to correct the data

UPDATE sometable

SET someColumn = REPLACE(someColumn,'cqs','CQS')

WHERE ...

Data in co_num column of customer table shows:

CQS0002509

CQS0002510

CQS0002511

cqs0002512

cqs0002513

cqs0002514

cqs0002515

CQS0002516

CQS0002517

CQS0002518

CQS0002519

CQS0002520

Tried the select statement as follows:

SELECT *

FROM co

WHERE co_num COLLATE SQL_Latin1_General_CP1_CS_AS like 'cqs%'

Results:

co_num

----------

cqs0002512

cqs0002513

cqs0002514

cqs0002515

which is exactly what I...

I am confused about 2 things regarding the restore script:

1) What is the "logical device" and how is that usually expressed? Same question for the physical device location?

...

Thanks Jeff, the script below worked correctly.

Thanks again for everyone's assistance and answers to my question.

Jefferey Williams wrote:

You can use EXCEPT to compare your tables:

SELECT {columns}

FROM db1.dbo.tablea

EXCEPT

SELECT...

GSquared wrote:

When you say you want differences, what exactly do you mean?

Do you just mean rows that exist in one that don't exist in the other? Do you mean...