[firebird-support] special string question

2013-03-19 Thread Olaf Kluge
Hello everybody, I would check a input string and change some character. For example: a or A = A Ä = [ Now I have create a table with all possible characters and the exchange character. Is there an simpler way than this? While count < strlength Character = substring(input from

RE: [firebird-support] special string question

2013-03-19 Thread Leyne, Sean
Olaf, > Is there an simpler way than this? > > While count < strlength > > Character = substring(input from count for 1) > > Select exchangecharakter from table where inputcharacter = character into > :newcharacter > > Newstring = newstring || newcharacter; Is the character mapping "user defi

RE: [firebird-support] special string question

2013-03-19 Thread Olaf Kluge
Hello Sean. Always yes. I would create files for the data medium exchange procedure dtaus-files (bank transactions) and only some characters are allowed. All possible chars are saved in my table with translation upper and so on. Now I would like to check each character. At the time I have creat

RE: [firebird-support] special string question

2013-03-19 Thread Leyne, Sean
Olaf, > Always yes. I would create files for the data medium exchange procedure > dtaus-files (bank transactions) and only some characters are allowed. All > possible chars are saved in my table with translation upper and so on. Now I > would like to check each character. At the time I have create