Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Debasis
Starting Member
2 Posts |
 Posted - 2007-11-08 : 02:13:18
|
| Can i use Translate function in sql server query? How i ll use? In my oracle, i m using a Translate function, but i want to run that in sql server. How to do that? |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-08 : 02:52:47
|
| have a look at the REPLACE function on Books Online. i think you'll find it's the same functionality as translate in oracleEm |
 |
|
|
Debasis
Starting Member
2 Posts |
Posted - 2007-11-08 : 04:28:29
|
| I am not able to find. Will u tell how to do that? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-08 : 04:31:09
|
Books Online is the help file that comes with sql server. did you mean you can't find BOL or you can't find REPLACE?from BOL... quote:
Syntax REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' ) Arguments'string_expression1'Is the string expression to be searched. string_expression1 can be of character or binary data.'string_expression2'Is the string expression to try to find. string_expression2 can be of character or binary data.'string_expression3'Is the replacement string expression string_expression3 can be of character or binary data.
Em |
|
|
|
|
|
|
Translate Function