Great! That worked!!  I knew it was easy

Ahem...

Much easier is this...

Declare @MaxLen TinyInt

Update dbo.Table Set dbo.Table.FieldName = Replicate('0', @MaxLen - Len(LTrim(RTrim(dbo.Table.FieldName)))) + LTrim(RTrim(dbo.Table.FieldName))

It all depends on the scenario!  For example, let's go with the classic example of Customers, Orders, and Order Details.  Sure, I would probably put a Cascade Delete on the...

AngelaBut is right, it was a little off track, but hey, I posted some suggestions before complaining .  Anyway, my last thought on...

I don't think mshiva is entirely correct.  I am able to access Tables from a Function.  Of course, these are "Table Valued" Functions and not "Scaler-Valued" Functions, but I don't...

In the immortal words of Dr. Evil..."RIIIIIIIGGHT"

Ok, this ALL depends on how Dynamic this needs to be.  If you foresee these Columns as changing in the future, or that you'll need more columns later, then use...

Gadzooks! 

Well, if you ever buy a program called "HEAT", watch out!  For all of these so called "Yes, we can customize it to your...

Actually, I do not believe you can even use Temporary Tables of the "##" type in a Function.  You can however Declare a Table Variable.

Declare @Table Table(ID Int Primary, Value VarChar(50))

Insert...

Lucky, I know how you feel, imagine that I have to work with a DB and one of the tables has 134 Columns (it stores Config data)!

What you're saying makes absolutely no sense.  Is the PKey a Numeric type right now and you're just trying to figure out the next number?  Or are you running some...

Well, if you're going to use an Access Data Project...make sure you choose "Project using Existing Data...".  This will allow you to choose the SQL Server.  However, if you're designing...

You can use QALite (Query Analyzer Lite), it's pretty good, although I have found some bugs.  It was programmed using .NET.  The retrieval time is almost exactly similar as Query...

Ok, ericp37 has a point.  If this is an existing app, you can create a Trigger very similar to what I suggested in the Stored proc, or I believe you...

Ok, this is simple.  Create a Stored Proc for saving data into that Table.  In that Proc, Clean the data!!!   I ALWAYS create...