Just another way...

SELECT REPLACE(STR(somecol,6),' ','0')

You know what they say... "Tuning makes perfect"   Keeps getting better and better...

Nicely done, Ian... didn't know the OP was doing the kind of stuff he said in a later post.

Heh... could be... the correct answer is "don't sort in a view".

Thanks Jesemine...

Heh... yeah... the only reason I don't upgrade the client tools right away is because we still use 2k at work and I need to be able to answer...

Scheduled Backups become "Jobs"... Find the [Management] folder for the database and expand it... find the [SQL Server Agent] folder under that and expand it... find the [Jobs] folder under...

--===== Order by with NULL last...
     -- Sort/Select all non-null... will be first in list
 SELECT *
   FROM YourTable
  WHERE YourColumn IS NOT NULL
  ORDER BY YourColumn
  UNION ALL -----------------------
     --...

Understood... I don't think there's a trick to do this or monitor this in 2k... if they can view the data, they can copy the data.

Heh... I've really got to get 2k5...  Just for grins, Jezemine, can you post the code as in your example for us 2k guys???  Would be interesting for me to...

Removing the "owner" privs is the only way... unless you encrypt everything.

Not to worry... no internal cursor...

Ok, Chris... but the OP did post some SQL Server 2k5 code.

{Edit}... sorry misread that... YOU have SQL Server 2k... I get it...

Curious...  Why do you have 3 email tables?

Heh.... I'm in the telephone business... case you haven't noticed, we round everything UP

Obviously, you'll need "SA" privs to do this...

--===== Declare local variables

DECLARE @DefaultDataPath SYSNAME

DECLARE @DefaultLogPath  SYSNAME

DECLARE @InstanceName    SYSNAME

DECLARE @KeyPath         SYSNAME

DECLARE @RootKey         SYSNAME

DECLARE @ServerName      SYSNAME

--===== Presets

    SET...