Viewing 15 posts - 31 through 45 (of 49 total)
One of my tasks every 6 months is to run a profanity check on our data!
I love it to bits cos I get to find out all the new...
September 25, 2006 at 9:03 am
Brilliant Sreejith
Thank a lot for that
for those who are doing the same thing though
Make sure you include 'end' in the Case function
And it will work fine
September 19, 2006 at 4:28 am
What is with your spelling in this installment? Good work all in all though Steve. I look forward to the break it gives me everyday and its content
March 22, 2006 at 6:47 am
Where col1 like '%''%'
If its a name that'll get your O'Doyles and O'Connors
March 3, 2006 at 7:09 am
what a great coffee table, now dem little old dears can play sodoku and snake and ladders(with their grandchildren) kids could spill their juices or paints and you could wipe...
March 1, 2006 at 7:22 am
Intresting, how do you mean store the value of soundex as a column ?(or did you mean store the value in a column)
unfortunately our DBA doesn't like us writing to...
February 15, 2006 at 2:49 am
Thanks Amit unfortunately it never is that easy, suppose you have two people entered at the Smith & Co Company
The First is Abbey Smith, the second is A B Smith
This would mean...
February 14, 2006 at 8:46 am
Okay So from the sample data below
John Smiths Ltd.
John Smith Limited
Paul Spanners Mortgate Consultants
Paul Spanners Mort. Cons.
Westfield I.F.A.
Westfield Independant Fin. Adv.
Money-World.Com
110% Profit
110% Profit(London)
110% Profit(Glasgow)
110% Profit(Lnd.)
John Smyth Limited
The query should return...
December 7, 2005 at 3:59 am
No worries , it did seem a little like a dig on those not so used to writing more refined queries.
As Vladan remarked this is purely for our sales team...
December 6, 2005 at 10:05 am
source Data could be something in the firm.NAME
John Smiths Ltd.
John Smith Limited
Paul Spanners Mortgate Consultants
Paul Spanners Mort. Cons.
Westfield I.F.A.
Westfield Independant Fin. Adv.
Money-World.Com
110% Profit
110% Profit(London)
110% Profit(Glasgow)
110% Profit(Lnd.)
John Smyth Limited
like wise the...
December 6, 2005 at 4:20 am
No this is not a joke, please bear in mind there are people who use this board who aren't as ofee with writing as many queries as you do that...
December 6, 2005 at 4:02 am
see I thought it was a bit of genius that code, I would have written a UDF but I haven't written one yet , suppose this would give me a...
December 6, 2005 at 2:32 am
LOL Thanks Frank
I just got my answer before I checked your post, what I did was
SELECT case
when patindex('%[0-9]%',ADR.ZIPCODE) > 0
then left(ADR.ZIPCODE,patindex('%[0-9]%',ADR.ZIPCODE)-1)
else ADR.ZIPCODE
end as prefix
I was really looking forward to...
November 28, 2005 at 5:09 am
it may be early and it maybe a locale thing,but what was the curse beginning ch---?
October 18, 2005 at 2:55 am
Cheers for thatI guess I better get cracking on all those case statements then ... lol should be fun (ps theres about 12 other case statements in the actual report...
September 9, 2005 at 7:23 am
Viewing 15 posts - 31 through 45 (of 49 total)