Subject Re: [firebird-support] how to suppress dashes in query results
Author Helen Borrie
Post date 2016-02-12T06:56:48Z
Re: [firebird-support] how to suppress dashes in query results Friday, February 12, 2016, 4:31:10 PM, Virna Constantin wrote:


SELECT * WHERE REPLACE(UsersField,'-') = 'MyValue'


Correction:

SELECT * WHERE REPLACE(UsersField,'-', '') = 'MyValue'

Another way to do this would be to define a computed
column for this search, viz.

ALTER TABLE MyTable
ADD SearchField COMPUTED BY (REPLACE(UsersField,'-', ''))

HB