Yes, it's definitely possible - I wrote a function in FoxPro to do this for printing onto cheques - I suggest a function in SQL would be possible

I have a similar arrangement on a few key tables and then a selection of columns that my client wanted audited. I added 2 columns to the table, one...

I think the problem is that data in table variables is always the subject of a Table Scan in the query parser - is it not possible to convert your...

Or you could of course use Visual Foxpro which would be far easier to control than say a VB application as it is a database itself....

OK float question, try this:

declare @x float,

@y numeric(16,10)

set @x=1.3333

set @y=1.3333

select @x

select @y

The answers speak for themselves...

table datatypes - you cannot force the query optimiser to do anything but a table...

Actually, I've just noticed you're using the float datatype - I hope you know this is not accurate - in fact it can be very inaccurate depending on what you...

I would be careful using the table variable type - for one thing I don't believe it supports INSERT...EXEC, but more to the point, it is not optimisable within the...

Forgive me if I'm missing the point, but I think you're talking about two different things at least...in my application, all client adjustments have a unique serial number which also...

It may be useful to see your table structure, but out of interest is mytable a table or a view?

I have seen a few postings here where people have put DBs on SANs and got mixed results. I think you need to have a very good infra-structure in...

I would add a word of caution - using the table data type may actually cause you more problems. I would actually recommend that you create a permanent table...

Rather than using xp_sendmail, perhaps you should look at using CDO - Collaboration Data Objects. These offer a much richer interface, which I believe includes X400 addressing.

Well without seeing the code it is difficult to say much. When you specify the ORDER BY clause, are you qualifying the column names with the correct aliases?

I have...

If your SELECT statement is non-critical, for example a web page that refreshes regularly so bad data won't matter, use the WITH (NOLOCK) hint after your table object name:

SELECT name...

I'm not sure about quick, but put this in your UPDATEs WHERE clause:

...AND CHARINDEX(' ',<<colname>>) > 0

Simon