Post reply

How to check only the numeric values at the same time ignoring the symbols or characters using SQL queries

  • November 14, 2011 at 2:17 am

    #1406991

    Dev (11/14/2011)

    My ONLY argument is this.

    Dev (11/11/2011)

    ID

    ---

    2|4|6

    It's bad design. If you have control on database schema, re-design it.

    Well, yes, it's usually a good idea to normalise at least as far as 1NF.:-)

    "can we try the same code...." didn't (and still doesn't, no matter how hard I look at it) appear to me to be about table design as opposed to about the code.

    Tom

  • November 14, 2011 at 2:32 am

    #1406998

    "can we try the same code...."

    Yes we can, subject to:

    •It’s the only query where we are doing it.

    •It’s not a referential column.

    It’s my observation on DB Designing practice, “If one table like this enters into DB Design, there would be 10 more in queue”.

    At last it's just a Best Practice. No enforcements at all.

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply