MS SQL: replace funkcija

Problem:

Potrebno je maknuti ili zamijeniti karakter (ili više njih) unutar SQL query-a

Rješenje: 

SELECT REPLACE(fieldName,'x','') AS rezultat FROM tableName

Ovo daje vrijednost polja fieldName gdje je slovo x zamijenjeno ničime, tj. x je izostavljen

SELECT REPLACE(fieldName,'x','y') AS rezultat FROM tableName

Ovo daje vrijednost polja fieldName gdje je slovo x zamijenjeno slovom y

This entry was posted on Tuesday, April 5th, 2011 at 11:12 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.