A pet peeve of mine...not a nationwide ban at all...handful of states ban talking while driving completely (think only 4 right now)...some have partial bans (mainly school bus drivers and...

If I understand you correctly, you want the position of the first occurence of '1' in your string...if so, then..

declare @string nvarchar(50)

declare @position tinyInt

set @string = '000000011111000'

set @position = charindex('1',...

It has now become a favourite travel game with us...

1)on long distance drives - count the # of people that drive past using cell phones.

2)in the airport - # of...

An example please - of data and char to be extracted...

for instance if you're looking for 's' in a string, you'd do something like this:

declare @string nvarchar(50)

set @string = 'abcdefghijklmnopqrstuvwxyz'

select...

Sorry - this has nothing to do with anything except that I haven't ribbed David in a long time and what with it being a Friday and all....

David - you...

LOL - the vehicle does tend to dominate the picture so the tools are easy to overlook - wish he had a composite leatherman (or some such) though - much...

Don't know anything about reporting services but if you're looking for a concatenating example, here's what you'd do...

DECLARE @emailAddresses VarChar(255)
SELECT @emailAddresses = COALESCE(@emailAddresses + ', ', '') + emailCol
FROM...

For an example, you could look at this post

Far as I know (& I'm sure someone'll happen by & tell me if I'm wrong - ) - you can only use this...

David - BOL has a pretty comprehensive explanation..the first 3 statements sum it all..

1) When a query is executed, it evaluates first the clauses linked with AND, and then...

I'm sure I have oversimplified this but given the sample data, this should get you started...

insert into Table2

select Col1, Col2, substring(Col3, 1, 2), substring(Col3, 4, 2), substring(Col3, 7, 2), substring(Col3,...

Search again and omit "insane"....think he has himself aligned with Alexander and not Nero...

(edited..forgot to explain the omission...)

aah - found what I was searching for - the many faces of Steve...

Be nice GPF2^...what's wrong..no one to pick on while on vacation...you really do rely on SSC...

My sympathies...

Hourly twice a year should at least get you that vacation home "now" than "then" so your best bet is to make this nightmare work for you and start...

I honestly didn't know that it's a problem getting a work permit for India...always thought the "flow" was from everywhere else in the world to the U.S - so do...