Here is some code to play with as well.

create table dbo.EmployeeWork

(

empid int,

CountryWorkAt Varchar(20)

);

insert into dbo.EmployeeWork values (1,'China');

insert into dbo.EmployeeWork values (1,'Germany');

insert into dbo.EmployeeWork values(1,'USA');

insert into dbo.EmployeeWork values(2,'China');

insert into dbo.EmployeeWork values(3,'India');

insert...

And before I go any further, please verify what version of SQL Server you are running. I just noticed that this is in a SQL Server 7/2000 forum, and...

So

select * from #mytable

should return 999.

Again, what are we trying to...

SQLRNNR (6/21/2012)

---

Koen Verbeeck (6/21/2012)

---

Oh god not him.

He's the most important reason I have such a high post count. Trying to help...

Also, didn't see you suggest any alternatives, so keep your snarkiness...

Yep, I missed changing a couple of sp aliases. Sorry.

ssc_san (6/21/2012)

---

Thank you Lynn.

You haven't answered the question, how does a SQL query know that '01-' is supposed to be '001' not '010'? You have said that '010' is not...

Try this script:

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET...

Based on the data provided, what is your expected output?

Wrong post, sorry.

Evil Kraig F (6/21/2012)

---

If these fields are all the exact same length than what's posted above by Lynn will work. I'm afraid I don't necessarily agree with Lynn about...

ssc_san (6/21/2012)

---

Lynn Pettis (6/21/2012)

---

ssc_san (6/21/2012)

---

Here is my problem, I would expect you want '010' not '007' if the '-' in '01-' were a '0', why would you expect '01-' to...

ssc_san (6/21/2012)

---

Here is my problem, I would expect you want '010' not '007' if the '-' in '01-' were a '0', why would you expect '01-' to be less than...

Here's one:

http://poorsql.com/

Because there are two columns with the value Company Name:

insert...