Or another option

SELECT 1.67574/10000.0 as conv_factor

Steve,

save us all the trouble and

Select * from posts where Thread = 'the thread' and message like '%smith%'

😀

Heres a quick example over 20 thousand rows , yes i know i said at least a million , but im rushing to go home

Drop table #dateList

go

Create table #dateList

(

UserId integer,

DateCol...

Compare the two methods over a large dataset (1 mill rows at least) . The method i documented will on require a single...

My article will help you with that

as you have discovered , Ascii will return the Ascii value of a single character.

So first of you need to cut the string into its single characters.

A good example of...

Can you show us what you have tried so for ?

What is your stumbling block in your own experiments ?

Apologies , i didnt read i properly , must learn not to rush so much.

TBH...

So if number = "1234" you want "49,50,51,52" ???

Please give a decent example.

So what is the error you get at run time ?

jcrawf02 (2/18/2010)

---

Odd, when I force a negative value, it doesn't change the identity incremental value at all? Try the last code, but set to negative anything, I assumed it would...

try this article on my blog

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx

To my mind it is rather a moot point, even if...

The issue is here....

BEGIN

DECLARE @ResultSet TABLE (

ReturnValue varchar(255) )

INSERT @ResultSet (ReturnValue)

EXEC master.dbo.xp_EncryptCreditCard @ccno

--select * from @ResultSet

UPDATE dbo.#Encrypt SET oprefno = (select ReturnValue from @ResultSet) where ccno = @ccno

End

The @ResultSet table...

Suddenly, im quite happy with my ISP.