Thanks sqlblues.

I had figured out, if I change the query as below, the list has become complete.

select REPLACE(part_code,'-','#'),part_code from s_stkmst

where REPLACE(part_code,'-','#')>= REPLACE('RYP1836-K','-','#') AND REPLACE(part_code,'-','#')<=REPLACE('RYP1836D-K1','-','#')

order by part_code

sqlblues (10/7/2013)

---

The only solution is to amend you part numbering to something that will sort the way you expect

drop table #s_stkmst

create table...

Seems like this works for me so far,

Select part_code, REPLACE(part_code,'-','#')

from A_Test

WHERE REPLACE(part_code,'-','#') COLLATE SQL_Latin1_General_Cp437_BIN >= REPLACE('RKS0516-W-Z','-','#') COLLATE SQL_Latin1_General_Cp437_BIN

ORDER BY REPLACE(part_code,'-','#') collate SQL_Latin1_General_Cp437_BIN

Thanks John

John, sorry for the confusion. I was trying many ways and mixed up the original code page I posted initially. Thanks for your tips and I will try it.

John Mitchell-245523 (7/25/2013)

---

If removing the space before the Z doesn't do it, please post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT...

John Mitchell-245523 (7/25/2013)

---

I think this is because you're putting a space before your "Z". And the outer REPLACE doesn't do anything - it just replaces a space with a...

John Mitchell-245523 (7/25/2013)

---

That'll be because "A" comes after "-" in SQL_Latin1_General_Cp1251_CS_AS and all the other collations you've tried. Here's a few options I can think of:

(1) Find a collation...

Hi Gail,

'Distinct' result is needed. Please refer to my code (revised) below and one attached file for imvolved tables and indexes.

Thank you,

SELECT DISTINCT

w.workorderno, w.date,...

You are right, can't open it in IE. But, if I click it in Firefox then it will direct me to use Sql Management tool to open it. I also...

Can u try to open this one?

(I can open it by sql2005.)

TQ

Hi Bru and Jason, thank you for your advice. Follow your advice, I will look for my missing indexes now. At the meantime, i attached my EP herein for your...

Hi Vidhya, thanks for your fast reply.

Now I can list out the directory content. I gave up using manual backup from SM at this moment because I am still unable...

This is the command as your advice was tried, (I enabled xp_cmdshell at the Server Surface Configuration and then issue this command)

EXEC master.dbo.xp_cmdshell 'C:\SQL2k5_Data'

and the result shows 'C:\SQL2k5_Data' is not...

Hi all,

In addition to Sunil's question, I am curious how to set the DB security to prevent being restored to other SQL Server by using a new 'sa'?

I meant,...