Problems with certain characters

[Marty Francom]

In my program I have a field for Initial  (single character field)  If a  + - . character is put in that field and the record is saved, then I get an:
     SQLite or SQLitening error            1 = near "+" : syntax error

Field is a character field.  Are character fields of 1 character long not allowed to have a  + - or .  character in them?   Why is that ?

I decided to use: 
   Replace$ chr$(0,43,0) with chr$(0,0) in sFld$
to remove these troublesome characters.   Is there a better way to handle the problem?  Are there other characters that would cause this problem?

     

[Fred Meier]

Be sure to enclose the + in single quotes.