Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: split string between 2 patterns

    Nice function.

    But, errors (Invalid length parameter passed to the LEFT or SUBSTRING function) if both search patterns exist and @secondpattern appears BEFORE @firstpattern.

    So I would enhance your function by...

  • RE: Conversion of a plain English problem into T-SQL

    Bill,

    If number is even

    n / 2

    which eventually reduces all even numbers to 1.

    Not so fast - it only reduces 2n quickly to 1. Some even numbers (18, say) bounce around...

  • RE: Conversion of a plain English problem into T-SQL

    My comment conveniently ignores the

    one of the things I am interested in is the count of how many repetitions of the sequence it took to reach 1

    but I...

  • RE: Question of the Day for 27 Jul 2004

    I think this QoD and the discussion about ANSI standards, extensions to the standard, behaviour of MS SqlServer vs Oracle etc should be compiled into a proper 'Featured Article' on...

  • RE: Question of the Day for 12 Jul 2004

    OK, I eat, sleep & dream T-SQL so this Question wasn't likely to confuse me (unlike any question with 'Bind' 'TCPIP' or 'Port' in the question, which scramble my brain). ...

Viewing 5 posts - 1 through 5 (of 5 total)