How can i use substr function with byte not character .sel substrb(col2||col1 from 1 for 12) from TEST;
Is there any way to do above? Like substrb oracle function?
Use the substring function, it works on both char and byte (as does substr)
try: substring(col2||col1 from 1 for 12)