Replace function in TEXT or NTEXT fields SQL Server We often use replace function in SQL server databases to find and replace a specific string. The SQL statement is straightforward and there is no any issue when we search and replace a string on a column with a datatype, not either TEXT or NTEXT. The general search and replace SQL statement is UPDATE tbl_name SET column_name = REPLACE(column_name, 'old_string', 'new_string') WHERE column_name like '%old_string%' The problem occurs when you try to search and replace a string on a column with datatype TEXT or NTEXT and the error message: Argument data type text is invalid for argument 1 of replace function. and SQL server do not have any recommendation on how to resolve, probably we know REPLACE function only work on varchar or nvarchar datatype The simplest way is converted TEXT or NTEXT data to NVARCHAR(MAX) and then use Replace function. Using below query you can replace string in TEXT or NTEXT data type column. UPDATE tbl_name SET column_name = CAST(REPLACE(CAST(column_name as nvarchar(MAX)),'old_string','new_string') AS NText) WHERE column_name LIKE '%old_string% This way you can replace strings in TEXT or NTEXT column.

Process is missing from React however it is installed through NPM

AnotherOps

I have been updating libraries on a React app last updated about 5 years ago. Here is the current issue when running the index.html through Visual Studio Code live server.

Error:

path.js:25 Uncaught ReferenceError: process is not defined
    at 2520 (path.js:25:17)
    at n (bootstrap:19:32)
    at 1316 (index.js:15:8)
    at n (bootstrap:19:32)
    at index.js:12:2
    at Main.js:15:27
    at Main.js:15:27

Package file:

{
  "name": "Tripsharing",
  "version": "0.0.1",
  "description": "Tripsharing website",
  "main": "index.js",
  "scripts": {
    "start": "./node_modules/.bin/webpack-dev-server --config ./webpack.config.js",
    "build": "webpack"
  },
  "repository": {
    "type": "git",
    "url": "git@github.xxx/tripsharing.git"
  },
  "license": "MIT",
  "author": "Mr So",
  "dependencies": {
    "@babel/core": "^7.18.10",
    "@babel/preset-env": "^7.18.10",
    "@babel/preset-react": "^7.18.6",
    "@turf/turf": "^6.5.0",
    "babel-loader": "^8.2.5",
    "csv": "1.1.0",
    "d3": "^4.5.0",
    "gsap": "^1.18.5",
    "immutable": "3.8.1",
    "jquery": "2.2.3",
    "json-loader": "0.5.4",
    "lodash": "4.12.0",
    "npm-check": "^6.0.1",
    "path": "^0.12.7",
    "process": "^0.11.10",
    "rc-slider": "^6.1.0",
    "react": "^16.14.0",
    "react-dom": "^16.14.0",
    "react-motion": "^0.4.7",
    "react-redux": "^5.0.2",
    "react-retina-image": "^2.0.5",
    "redux": "^3.6.0",
    "textures": "^1.0.5",
    "webpack": "^5.74.0",
    "webpack-dev-server": "^4.10.0"
  },
  "devDependencies": {
    "grunt": "~0.4.5",
    "grunt-contrib-concat": "~0.5.0",
    "grunt-contrib-nodeunit": "~0.4.1",
    "grunt-contrib-sass": "~0.9.2",
    "grunt-contrib-watch": "~0.6.1",
    "webpack-cli": "^4.10.0"
  }
}