• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to concatenate inside an escape function for Derby

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Don't worry about the logic yet, I wonder how I can concatenate inside an escape function
I want to say if the person's birthday is 1950-10-10, I will get something like 2013-10-10
The above shows the following error
Error code -1, SQL state 42X01: Syntax error: Encountered "||" at line 8, column 100.
Any ideas?
Thanks
Jack
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!