Sean Lange (9/15/2014)

---

BWFC (9/15/2014)

---

Sean Lange (9/15/2014)

---

Lynn Pettis (9/13/2014)

---

SQLRNNR (9/13/2014)

---

Sean Lange (9/13/2014)

---

Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to...

Sean Lange (9/15/2014)

---

Lynn Pettis (9/13/2014)

---

SQLRNNR (9/13/2014)

---

Sean Lange (9/13/2014)

---

Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first...

create table #tblRegistration

(

Phone1 varchar (10)

)

insert into #tblregistration

select '9334457582' union

select '1234567890'

select

replace(Phone1,SUBSTRING(phone1,3,6),'******') ---This one

from #tblregistration

drop table #tblRegistration

This should stop the error message. Just include the marked...

gouri92 (9/15/2014)

---

[font="Arial Black"]Hi,

I have 10 digit Mobile numbers in one column of table.

I have to display the data in the following way

933445758293******82

123456789012******90

I have to display two digits from starting and...

Eirikur Eiriksson (9/15/2014)

---

Quick solution, allows for variable length input

😎

;WITH SAMPLE_DATA(MOBILE) AS

(SELECT * FROM

(VALUES

('9334457582')

...

declare @Mobile as varchar(10) = '9334457582'

select replace(@mobile,SUBSTRING(@Mobile,3,6),'******')

Does this do what you want?

I went to sleep humming that damn song and it's still stuck in my head now!! I did take it upon myself to share it with...

SQLRNNR (9/10/2014)

---

Sean Lange (9/10/2014)

---

Both...

Try this

set dateformat dmy

declare @Date varchar(max) = 'Fri 14/01/2009'

declare @processed date= reverse(left(reverse(@date),10))

Pork chop

Sawdust 🙂

Grant Fritchey (9/4/2014)

---

BWFC (9/4/2014)

---

Grant Fritchey (9/4/2014)

---

The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry...

Grant Fritchey (9/4/2014)

---

The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry level data professional...

Stuart Davies (9/3/2014)

---

Sadly yes - but only in an evaluation way. From memory you have to tie into their...

Has anybody out there got any experience with Serif WebPlus x5?