...yes, and it's Friday and here in my place just about the right time to go home.

Enjoy your weekend!

The usual case here in Germany is about 30 working days. Usually right from the start. And Saturday is not counted as a working day.

Depending on your age you might...

Yes, we have shared here more than one cyberspace beer and laughter.

Also http://www.microsoft.com/technet/community/chats/trans/sql/05_feb15_sql.mspx

Be careful! Last time I said something similar, David Burrows called me a "sycophantic fool from Germany"

Frankly, I'm not sure on this. It looks interesting, but I suspect running through every position in a string slower than just checking with PATINDEX. Especially when there are more...

Thanks!

I should have flipped to page 3 here http://www.acronymfinder.com/af-query.asp?acronym=np&String=exact&page=3 

Only moderators can move it. But it's okay for now. Don't start another thread.

Carefully answering your question. In most cases it is better to apply the latest service pack. But...

Have a look here

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

and compare this to the result of SELECT @@VERSION to see it you miss a patch for SQL Server 7.0

FWIW:

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

 RETURNS VARCHAR(20)

 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 dbo.RemoveChars('a1sdsad124325143gffdfd4dgsf')

DROP FUNCTION...

And more efficient. A $80,000 developer with a few years of experience with your business is often a much better bargain than a $30,000 new hire every two years.

But...

Tststs, such answers are inappropriate here

One might be inclined to presume you do some basic research on your own, before asking a question. This is...

NP

What does this stand for?

Curtis,

I believe this only to be a small part of your proc. What are you dealing with? By any chance, are you dealing a time value...

Just out of curiosity:

What is SDET?

Last time I looked "Now()" wasn't an SQL Server function

Gee, and I always wondered wtf it didn't work

Chris,

if your date data contains a...