Yeah he can be a bit funny cant he.

I dont have any rows full of nulls in my table at the moment.

Every row has a value for every column and...

All right Ming tell me then how you would do this in a way that so when

new constants are added to the table (almost daily) I wouldn't have to go...

Thanks for the response.

The reason I am doing it as a string built up is that alot of our procs have optional parameters and as far as I know you...

Yes the table structure is bascially the same and that select will give me one currency or a list of price ranges grouped by currency like:

LowLimitHighLimitCostCurrencyCurrencySymbol

11130.0000Dollars$

219120.0000Dollars$

2029110.0000Dollars$

3039100.0000Dollars$

1199.0000Pounds£

21989.0000Pounds£

202979.0000Pounds£

303969.0000Pounds£

but I dont want that...

Create Function dbo.udf_STRIP_HTML

(

@Dirty nvarchar(4000)

)

returns nvarchar(4000)

as

begin

declare @Start int,

@End int,

@Length int

while charIndex(' 0 And charIndex('>', @Dirty, charIndex(' 0

begin

select @Start = charIndex('', @Dirty, charIndex(' 0

...

I did this for a colleague the other day who had a similar problem with some help from BOL.

He had originally written a recursive function to draw out a tree...

You could pass the data into your stored proc as a comma delimited list of values eg 12,14,16,23

I have used this method in ASP when saving selected items from a...

im using standard ADO.

Its a website written in ASP. I need to store default and custom emails with placeholders. Return the text/html replace the placeholders with values then send off...

what if the size of the Text data is bigger than the rowsize does it not get cut off.

I thought you had to use readtext.

if i can get all the...