# 1080 Using Field Names with Spaces in Them Inside of SQL Expressions Causes Type Mismatch Error

---

I am using Delphi 6 and DBISAM C/S version 3.08 How to duplicate using DBSys:

1. Create a table with 2 fields of type BCD size 2

2. Enter data for the new table using DBSys and enter the following:

Value 1 Value 2
12.50 12.60
10.80 13.00
45.23 46.23

3. Execute the following SQL: select sum("Value 1" - "Value 2") from new

You will receive the following error:

DBISAM Engine Error #11949 SQL Error - Type mismatch between column 'Value
1' and constant 'Value 2' in source columns

Note you can make this work by type casting value 1 and value 2 as a float.