SELECT SUBSTRING(phonenumber,1,charindex('.',phoneNumber)-1) from table

DRAFT

How to rewrite this block in Oracle?.

[font="Comic Sans MS"]AdventureWorksDB.msi source code, 28053K, uploaded May 8 2007 - 292342 downloads

AdventureWorksDBCI.msi source code, 29177K, uploaded May 8 2007 - 41144 downloads

AdventureWorksBI.msi source code, 7393K,...

Thanx Chris.

But my Problem is slightly Complex.What will be stored in strquery

is a large dynamic query with many conditions.So Please suggest

a way to directly use StrQuery if at all...

Create Table #employee

(

Empid int,

Employee varchar(20)

)

Create Table #employee1

(

Empid int,

Employee varchar(20)

)

Insert into #Employee values('1','Sirish')

Insert into #Employee values('2','Sateesh')

Declare @Strquery varchar(100)

SET @StrQuery='Select Empid,Employee from #Employee'

EXEC('INSERT INTO #employee1 (Empid,Employee) SELECT ''+@Strquery+''')

Select * from #Employee1

Getting Some...

After little bit of google search i came up with the following....

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(object_id) LIKE '%SPname%'

UNION

SELECT Name...

declare @name varchar(50)

set @name = 'Smith,Fred,John,J.Smith,Ann,Mary,Ken,Ted,quen,Kin'

What about separating more names?

Will the same query work?