Re: How do I separate in SQL

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 06:14:32 -0500

Try this page - http://www.algonet.se/~sommar/arrays-in-sql.html 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Newbie" <noidea@nospam.com> wrote in message
news:%23OZdHR06DHA.2392@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a field that uses "," to separate items
>
> Eg
> apple, pear, orange
> Monday, Tuesday, Wednesday, Thursday
>
> How can I split this into columns based on where the "," appears
>
> ie. Expected Result
> apple
> pear
> orange
> Monday
> Tuesday
> Wednesday etc
>
>

Relevant Pages

  • Re: Need for a budget sub-MacBook?
    ... If Apple could lean towards the latter, ... same sort of margin as the kind of stuff Apple shifts. ... off from this newbie market. ... Clearly they don't think this market is ...
    (comp.sys.mac.advocacy)
  • Re: opinions on logical OR variation
    ... However, presumably a product cannot be both an apple and an orange, ... #define PEAR 3 ... #define PLUM 4 ... > void do_something ...
    (comp.lang.c)
  • Re: fruit and vegitables
    ... Nicky wrote ... > Alan Hardy wrote ... >> Half a pear or apple? ... > I haven't eaten a pear since about 2 months after dx, ...
    (alt.support.diabetes)
  • Re: Array to single row -- Any simple way to do this?
    ... > array of multiple rows and columns into one row of values which have ... > 1 Apple ... Pear ... > 2 Grape ...
    (microsoft.public.excel.misc)
  • Re: Comparing Cell Contents using a Case statement
    ... Case InStr(1, l, "apple", vbTextCompare) ... MsgBox "apple" ... Case InStr(1, l, "pear", vbTextCompare) ...
    (microsoft.public.excel.programming)