Actually, it is impossible to convert GUID into numeric in T-SQL.

The largest exact numeric data type in SQL Server has maximum precision of 38.

To convert GUID you need 39...

Lynn Pettis (9/18/2012)

---

If you start with a million it...

There are two T-SQL features which support limited regular expression functionality:

LIKE operator and PATINDEX function.

Depends of what you really need it for.

Note, the more complicated operation involved (eg. pattern...

I'm glad to help, but make sure you understand how it's working. Otherwise you may have a trouble when someone ask you to explain it...

Roland Alexander STL (9/21/2012)

---

Oh,...

Sean Lange (9/21/2012)

---

This is one of the reasons it is generally considered best practice to always include schema when referring to any object. And if the schema is not in...

Michael Valentine Jones (9/21/2012)

---

kingdonshel (9/21/2012)

---

I have server Admin password, however even when I choose the AdventureWorks Database from the dropdown and run the below query I get an errror...

CREATE FUNCTION dbo.f_OhMyGod (@str varchar(100), @pattern varchar(100)) RETURNS VARCHAR(100)

WITH SCHEMABINDING

AS

BEGIN

SET @pattern = '%' + REPLACE(REVERSE(LEFT(@pattern, LEN(@pattern) - 2)),')n(',')[0-9]%(')

SET @str =...

Ok, this kind of work is not for T-SQL to do.

You will be best to create CLR function for this. Your IndexKey is not really a Key, but a pattern....

dwain.c (9/21/2012)

---

Eugene Elutin (9/21/2012)

---

SELECT COS($)

Will do the same, but it's to obvious...

I think the harder question would be: How to return 4 without using number in SELECT,

finding SELECT LEN($),...

SELECT COS($)

Will do the same, but it's to obvious...

I think the harder question would be: How to return 4 without using number in SELECT,

finding SELECT LEN($), would be a...

erics44 (9/21/2012)

---

of course it...

Greg Snidow (9/21/2012)

---

Yes, the main application at my company is...

Hi,

And I am expecting you to read and follow forum "how to post questions" guide....

Of course we are!

Just allow the option that it was intentional...

Everyone can hurt a poet :crying: