schaapie
Member
Is it possible to select an entry of a db-column as a view-column?
We have a field that contains a delimited list in the db and I want to present these as separate values to the customer in a view.
What I would like to do is:
Is there an Entry-function in sql?
Or is it possible to do this with a stored-procedure?
Any suggestions...?
Niek
We have a field that contains a delimited list in the db and I want to present these as separate values to the customer in a view.
What I would like to do is:
Code:
[LEFT]SELECT TABELALGEMEEN . CODE,
TABELALGEMEEN . IDTABELALGEMEEN,
Substring ( TABELALGEMEEN . OMSCHRIJVING , 1 , 1 ) as subid,
Entry ( 1 , TABELALGEMEEN . OMSCHRIJVING , ',' ) as subid2,
TABELALGEMEEN . OMSCHRIJVING
FROM PUB . TABELALGEMEEN
WHERE TABELALGEMEEN . TABELCODE = 'Something'[/LEFT]
The substring works, the Entry doesn't.
Is there an Entry-function in sql?
Or is it possible to do this with a stored-procedure?
Any suggestions...?
Niek