And here is a soundex example.

;with tempData as

(select 'star' Company union select 'stir' union select 'My Fab Company')

select company from tempData

where soundex(company) like soundex('str')

engrshafiq4 (9/6/2011)

---

i want to search the no of characters in a field and to show the record having more characters matched.

how i can do these steps in stored proceedure

1)load all...

The code sample provided by ColdCoffee works fine except that it also assumed you would want to update strDomainName. So just exclude that part of the update and you're done:

UPDATE...

Perhaps the lack of response is the result of a lack of question.

harry.sh16 (8/29/2011)

---

I already have a package that loops through different (ADO) objects and loads 3 different excel destinations dynamically, need to change excel to access destination dynamically so that it...

So which bit is giving you problems? Are you able to import the file using a fixed-width flat-file connection manager? Or perhaps it is the breaking down of the data...

Pulivarthi Sasidhar (8/29/2011)

---

Hi All,

The CSV file is fixed length with no delimeter, contains rows.

ex:- single row contains

1asdusa1Comp2Elctr3Mech1Engg2Degre

sno,sname,scity,cno,cname,cno,cname,cno,cname,cno,cname,dno,dname,dno,dname,dno,dname

1,asd,usa,1,Comp,2,Elctr,3,Mech,4,Fina,1,Engg,2,Degre

Single row Contains- 3 datasets.

Student (sno,sname) -1 row

Class(cno,cname)- 4 rows

Department(dno,dname)-2 rows

How can i split...

akl (8/26/2011)

---

the restore to another server requires too many steps. back up prod, copy file across network, run restore, remove users due to login SID changes and restore users. I...

I assume you've decided against using BACKUP/RESTORE for some reason? That would be the simplest.

drew.allen (8/26/2011)

---

I think this is what you are looking for.

WITH Test(TestField) AS (

SELECT 'aaa'

UNION

SELECT 'abc'

UNION

SELECT 'bbb'

UNION

SELECT 'bcd'

UNION

SELECT 'ccc'

UNION

SELECT 'cccccc'

UNION

SELECT 'cccccccccccccccccccccccc'

)

SELECT *

FROM Test

WHERE NOT TestField LIKE '%[^' + Left(TestField,1) + ']%'

It...

peanuts91 (8/26/2011)

---

Thanks Phil,

but actually I need to check if all characters in my string are the same without to know the length of my string.

Tell me if I'm not clear...

peanuts91 (8/26/2011)

---

Hi guys,

In order to clean up some tables in my database I would like to find all records like 'aaaaaaaa' or 'bbbb' or 'ccccc'....'zzzzz'.

Is there any functions existing to...

John Mitchell-245523 (8/26/2011)

---

Henk

I don't know of any way to change the order in which the derived columns are displayed. However, I can't think of any reason why it would...

Are you really intending to put millions of rows into a spreadsheet?

May I ask what the business driver is? - there might be a better alternative.

...and you should check the date of the original posts 🙂