determining the nth character of a field

[t16turbo]

how can I determine the 7th character of a field?
I need to use this in an IF statement to set a string variable.
any ideas?

 

[t16turbo]

RIght, I managed to figure this one out with a basic IF statement :

IF mid(cst_DSTI_PROJ_REF, 7, 1) = "D" then
g_label = "Development"
elseif mid(cst_DSTI_PROJ_REF, 7, 1) = "S" then
g_label = "Design"
END IF

I now need to embed this within another statement that checks if the first 2 digits of the project reference are "D0" first. If they are, then do the above statement, else take the 9th character.

my code returns an error in actuate which has a yellow arrow pointing to the nested IF statement.
can anyone see any problems with this?

if mid(cst_DSTI_PROJ_REF, 1, 2) = "D0" then
	(IF mid(cst_DSTI_PROJ_REF, 7, 1) = "D" then
	g_label = "Development"
	elseif mid(cst_DSTI_PROJ_REF, 7, 1) = "S" then
	g_label = "Design"
	END IF)
elseif mid(cst_DSTI_PROJ_REF, 9, 1) = "D" 
then
	g_label = "Development"
elseif  mid(cst_DSTI_PROJ_REF, 9, 1) = "S" 
then
	g_label = "Design"

	END IF

thanks