Re: Data Fixing.
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/21/04
- Next message: karendavis_at_optonline.net: "My new nipple and vagina piercings"
- Previous message: Phil: "Data Fixing."
- In reply to: Phil: "Data Fixing."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 14:12:03 +0530
hi phil,
See following example and the query on the basis of example,
-- sample data
create table t(address varchar(500))
insert into t values('Clarice Apartment-2 Bedrooms Apartment')
insert into t values('The Beech-4 Bedrooms Detached')
-- required query
select left(address, charindex('-', address) - 1) 'name',
substring(address, charindex('-', address) + 1,
(len(Address) - charindex(' ', reverse(address)) + 1 ) - charindex('-',
address) )'bed',
right(address, charindex(' ', reverse(address)) - 1) 'type'
from t
-- Vishal Parkar vgparkar@yahoo.co.in
- Next message: karendavis_at_optonline.net: "My new nipple and vagina piercings"
- Previous message: Phil: "Data Fixing."
- In reply to: Phil: "Data Fixing."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: UDF and SQL2000 - Why doesnt this work?
... Basically This is what I want to do - I have created a query ... as DDL
(i.e. CREATE TABLE statements; ... Sample data that illustrates the problem, ...
Expected output from the sample data supplied; ... (microsoft.public.sqlserver.programming) - Re: New to SQL and trying multiple table joins
... > Can't be certain of how to write this query for you without DDL (CREATE ...
Previous msg edited plus added in keys, and sample data at end. ... EmpAvailID (Primary
Key), EmpID, EAMonthID(Foreign ... AbilityID, EmpID, MainAbility ... (microsoft.public.sqlserver.programming) - Re: find missing time periods
... User and UserShiftStart in sample data, ... I believe your unmatched query
actually ... FROM [Time Periods], Splits; ... (microsoft.public.access.queries) - Re: Insert with multiple subqueries - possible?
... JetSQL is not the same as Transact-SQL. ... > Sample Data: ...
> which is a list of Student Numbers and Course Codes ... > be possible to do it
in one) - this is the query I cannot get to ... (microsoft.public.sqlserver.programming) - Re: 2nd try, left join
... Thank Bob. ... and it seems to loop forever and return results in the millions
when the highest result doing the query on Pet column at a time is less then 15000. ...
>> You're going to need to provide some sample data and desired results ... >
quicker response by posting to the newsgroup. ... (microsoft.public.inetserver.asp.general)
