[SQL] help

Hi, I have a table in which the data's are entered like, Example: One (1) Two (2) Three (3) I want to extract the data which is only within the parentheses. that is 1 2 3 Thank You Nicholas I

Re: [SQL] help

select substring( data from '\((.*)\)' ) from table; 2010/5/5 Nicholas I nicholas.domni...@gmail.com: Hi, I have a table in which the data's are entered like, Example: One (1) Two (2) Three (3) I want to extract the data which is only within the parentheses. that is 1 2 3

[SQL] Celko take on EAV

This question isn't a flame bait for the merits of the EAV. I'm rereading my Joe Celko's SQL Programming Style and I noticed an interesting comment regarding the EAV model (of course he discourages its use): There are better tools for collecting free-from data. What tools was he referring to?

Re: [SQL] Celko take on EAV

On 5/7/2010 12:33 PM, Richard Broersma wrote: This question isn't a flame bait for the merits of the EAV. I'm rereading my Joe Celko's SQL Programming Style and I noticed an interesting comment regarding the EAV model (of course he discourages its use): There are better tools for collecting