Can't use the REPLACE function in netbean's JavaDB?

Asked May 03 '21 at 18:33

Active May 03 '21 at 20:00

Viewed 25 times

Firstly, I'm new to SQL - not so new to Java anymore.

Secondly, I'm using NetBeans 8.2 with JavaDB and when I'm trying to run a SQL query, such as:

SELECT Replace(BOOKNAME, ' ', '') from BOOKINFO;

and try to execute the commend, the console displays an error, namely:

[Exception, Error code 30,000, SQLState 42Y03] 'REPLACE' is not recognized as a function or procedure.

Any ideas on what I can do? Do you see something wrong with my query code?

edited May 03 '21 at 20:00

asked May 03 '21 at 18:33

wing

which dbms are you using? is it DB2? – eshirvana May 03 '21 at 18:39
Using SQL Server – wing May 03 '21 at 18:42
1

"JavaDB" is the name of the Apache Derby open source database. SQL Server is a Microsoft product. – OldProgrammer May 03 '21 at 18:44
I am studying, so some things are not well understood, thanks. – wing May 03 '21 at 18:48
so the question is no longer needed ? if so please close it or update it. – Mauricio Gracia Gutierrez May 03 '21 at 19:34

0 Answers0