pcsoft.us.windevCopyright 2026, PC SOFT29 Feb 2016 15:00:10 Z29 Feb 2016 13:38:10 ZI have a query like this: [code:sql] select 'Gesamt VDA' as bez, sum(anzahl) menge from soko where left(nummer,4) = '1601' and art = 'V' [/code] My Result shows NULL as a value for bez instead of 'Gesamt VDA'. Why is that? Is there a way to declare a string as a field in HFSQL? TIA Sebastian -- http://arnoldconsult.de WinDev 20 with Oracle, WinDevMobile Android Apps and Motorola Windows CE Mobile Barcode Scanners, Python 3 with Oracle and MySQL30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Sebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field-56645/read.awp29 Feb 2016 15:00:10 ZThis is without code, all within HFSQL Control Center. The point is [code:sql] select 'something' as column_name ... […https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field-56645/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field-56645/read.awpHFSQL SQL String as fieldAttlebaxpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field-56643/read.awp29 Feb 2016 14:28:18 ZWithout seeing the code around this statement it is fairly hard to work it out. However SQL in Windev is fairly standard. So …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field-56643/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56642-hfsql-sql-string-field-56643/read.awpHFSQL SQL String as field