Joined: 09 Aug 2001 Posts: 257 Location: Malmö, Sweden
Hi,
I have a compute node in the BLOB domain where I have to add CRLF (hex 0d0a) after some end tags.
I wonder if there is any way to cast from in my example CAST ('</MESSAGE>' AS CHAR HEX) instead of using the hex-string - '3c2f4d4553534147453e'.
No, I don't speak hex fluidly.
-- </MESSAGE>
SET Pos = POSITION( '3c2f4d4553534147453e' IN StrResult);
IF Pos > 0 THEN
SET StrResult = SUBSTRING(StrResult FROM 1 FOR (Pos + 19 )) || '0d0a'
|| SUBSTRING(StrResult FROM (Pos + 20) FOR StrLength);
END IF;
Reading the ESQL Reference manual I can't see a way of doing this.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum