I am trying to write a stored function which will return the uninsulated (20) type. I want to format this return value by putting string, itn, float value. But I did not understand how I could add binary data.
Construction work 'test' () returns binary (20) BEGIN v binary declaration (20); Set v: = CAST ('test' as binary); Set v: = v || Cast (in the form of 5 binary); - I want to add 5 as binary but how? Return vi; END writes the first line test as a binary, in the second row I want to add 5 as binary. How can I do that? Thank you all ..
- You want to use:
< Code> SET v: = CONCAT (v, CAST (5 AS BINARY)); CAST (5 AS BINARY) , instead of , you can use shortcodes.
Comments
Post a Comment