On 5/7/2010 12:33 PM, Richard Broersma wrote:
>
>
> 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
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?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles P
select substring( data from '\((.*)\)' ) from table;
2010/5/5 Nicholas I :
> 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
> N
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
