You can change this by script. You save the modifications EM is suggesting in the change script and run this whenever you want.

May I say that it is a huge...

SELECT

     *

FROM

     sysindexes i

WHERE

     i.indid BETWEEN 1 AND 254

     AND OBJECTPROPERTY(id, 'IsUserTable') = 1

     AND INDEXPROPERTY(id, name, 'IsStatistics') = 0

ORDER BY

     OBJECT_NAME(id)

     , i.indid DESC

should...

Cute! But what a shameless plug this is, Adam!

What do you think of this slight modification?

CREATE FUNCTION dbo.PatternReplace

(

 @InputString VARCHAR(4000),

 @Pattern VARCHAR(100),

 @ReplaceText VARCHAR(4000)

)

RETURNS VARCHAR(4000)

AS

BEGIN

   DECLARE...

May I add, that I strongly would consider having two columns instead on one?

I might be wrong on this, but I suspect this is one of the few occasions where EM comes in handy. IIRC, you can do this in EM table design...

Proud to give credit for the UDF to Jonathan van Houtte!

To correct be explicit in your datatyping. ...

Yes, like I stated somewhere above...

But it was nice trick to confuse some people in the German...

INSERT INTO...SELECT... should help

See, if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Please refrain from multi-posting. See my answer here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=153940

Have a look at "linked server" or OPENQUERY in BOL.

The answer lies within what you have done.

REPLACE apparently converts the whole second string to NCHAR, since NCHAR has a higher datatype...

I have the original MS training books, which I consider fairly good. Apart from them, do a search here in the fora (especially the certification forum). The question for good...

CREATE FUNCTION dbo.RemoveChars(@Input varchar(1000))

 RETURNS VARCHAR(100)

 BEGIN

  DECLARE @pos INT

  SET @Pos = PATINDEX('%[^0-9]%',@Input)

  WHILE @Pos > 0

   BEGIN

    SET @Input = STUFF(@Input,@pos,1,'')

    SET @Pos = PATINDEX('%[^0-9]%',@Input)

   END

  RETURN @Input

END

GO

SELECT 'a1sdsad124325143gffdfd4dgsf',dbo.RemoveChars('a1sdsad124325143gffdfd4dgsf')

DROP FUNCTION...

See, if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx