[SOLVED] Stored True and False in one string separating them

[madref]

I store a few true and false statements in one string where 1 = true and 0 = false in my database.
In Lazarus you can individual target a single letter in a string with

Code: Pascal  [Select][+][-]

1. MyChar := MyString[1];

In SQLite you can change the name of a field with the 'AS'-statement


Is it possible to separate them in individual statements in SQLite?


I was thinking along

Code: SQL  [Select][+][-]

1. SELECT RS_Observed [1] AS Referee1, RS_Observed [2] AS Referee2, RS_Observed [3] AS Linesman1, RS_Observed[4] AS Linesman2 FROM tbl_Observations

[madref]

Next time i should google first.


Found my own solution again 
USE SUBSTR (X,Y,Z) for more info looks here

Code: SQL  [Select][+][-]

1. SELECT SUBSTR(RS_Waargenomen,1,1) AS Referee1, SUBSTR(RS_Waargenomen,2,1) AS Referee2, SUBSTR(RS_Waargenomen,3,1) AS Linesman1, SUBSTR(RS_Waargenomen,4,1) AS Linesman2  FROM tbl_Rapport_Straffen