Presentation of data should be handled on the client side. If you must do this on the server this will work

DECLARE @val smalldatetime

SET @val = getdate()

SELECT ...

All good altrnatives but the easy way is to not use varchar. If you use Char(10) you know your string will always be 10 characters long.

Mike

Displays of naked greed are never pleasant. Or perhaps greed is the wrong word in this case. Many of the people involved here may have...

Phil what criteria are you using to set the value of Field3? Is it possible for Field3 to be 0 for all rows or must 1 row always have Field3 ...

If you know which identity values have not been used or were deleted you can use the SET IDENTITY_INSERT statement, and insert an explicit value into the identity column. Check...

There is usually a better choice for PK's than an identity integer. If there is not a single column that is a natural PK then use a composit PK. First Name,...

"you could use this(i'm a minimalist you see...

"

Why is it that the bigest brightest and best always claim to be minimalist.?

Mgyar anyone who has...

LOL...the "Do Not Push" button takes you to the EULA.  Not that I acutally pushed it...a friend told me... 

I bet they have a counter...

"Some of you guys need to date more!"

Gee I knew that.  Remi plays pool but I could use a few phone numbers.

Mike

If you are using an Access form you can link each textbox to a value from the Db. When you load the cells (i.e. move to a new row)...

"Hi, my name is Steve, and I'm a Microsoft Co-Dependent"

<answering murmers of "Hi, Steve!" from the group>

Who will join me??

... and what do we call it??"

I have no clue...

Brian, you do not need to pull the totals. They can be recomputed from the data.

Mike

oops...there I go with my aggressive analogies again!

you do have aggressive analogies perhaps the mouse in...

Remi not only do you type answers to questions faster than I do but you type questions to questons faster than I do.

It is funny and I am still lost. Ok let me see, we have pictures in the database and some of these pictures are similar. Greyhounds, Boxers, pit bulls, chows,...