Daniele,
In addition to my earlier suggestion, you may also want to try the option of "FORMATTED" in your CHOOSE command.
Very Best Regards,
Razzak.
At 02:27 PM 3/20/2003 +0100, Daniele Barbieri wrote:
I've a column containing a text string that begin with blank characters like ' abcdefghi.....'
The command: SET VAR Varname=colname IN tablename WHERE...... work OK and Varname contain ' abcdefghi...' (with initial blank characters)
The command CHOOSE Varname FROM #VALUES FOR (........), colname..... return the string without the initial blank characters ( 'abcdefghi.....')
Daniele,
I believe, you are using the latest and greatest 6.5++ for Windows.
01. Check the FONT SETtings:
SHOW FONT
02. Try the following quick test at the R> prompt:
SET VAR v1 TEXT = (' ABC,DEF,GHI')
Notice the leading blank space in front of ABC.
CHOOSE vPick FROM #LIST .v1
How does it look?
Do you see the leading blank space in CHOOSE?
03. Try various combinations with different FONT SETtings:
SET FONT ANSI
SET FONT OEM
SET FONT COURIER
SET FONT SYSTEMVery Best Regards,
Razzak.

