Yes you can 🙂

Results from my machine (i am not sure of my desktop's age :w00t: , but i can tell its faster than urs :-P)

========== ColdCoffee ==========

SQL Server Execution Times:

...

The location is here:

But i wonder if we can restrict access to system functions. Am so weak in Administration of SQL Server, so sorry, i cant help you!

You're welcome Doug!

Lawrence, you can make use of REPLACE function to perform the operation, like this:

DECLARE @Table TABLE

(

Name VARCHAR(20)

)

INSERT INTO @Table (Name)

SELECT '123 Bib Fortuna' ...

You bet 🙂 :w00t:

I am assuming u are very baby SQL 🙂 developer (No pun intended) . This requirement is the basic concatenation of 2 columns.

DECLARE @Table TABLE

(

ID ...

A good explanation of the problem, and though the sample data is not readily consumable, it was not tedious to make it readily-consumable.

Now the business:

I have build the sample data...

mtassin (2/8/2011)

---

Heck I didn't understand what he was doing with the CTEs till...

Wolfmeister (2/7/2011)

---

If my understanding is correct then this method uses a tally table in conjunction with the SUBSTRING function to get the starting positions of each character in @string, and...

Wow, accolades from the highest quarters 🙂 Thanks , Jeff. 🙂

You're welcome,Mr.Wolf 😉

How about this:

declare @string VARCHAR(100)

SET @string = '12345'

;WITH

TENS (N) AS (SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL

...

What does local time mean ? Wouldn't "local" refer to elsewhere ? whats your local ? Calculate the time difference between your local zone and Isreal Standard Time and use...

Try this:

select column1

from

( select '8343_1'

union all select '3327'

union all select '4362'

union all select '2155_2' ) tablename (column1)

where...