Click or drag to resize

ExtensionToCorrectSQLValue Method

Correcting SQL value for SQL WHERE clause

Namespace:  Velo.Data.Helper
Assembly:  Velo.Data (in Velo.Data.dll) Version: 22.2.10.1 (22.2.10.450)
Syntax
Copy
public static string ToCorrectSQLValue(
	this string pValue
)

Parameters

pValue
Type: SystemString
SQL value to corrected

Return Value

Type: String
Correct SQL value

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type String. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
Remarks
character ' trigger an exception

example exception message: Incorrect syntax near 'bürgen'. Unclosed quotation mark after the character string ';'.

Replace ' to _

character & found 0 addresses

Sub string to character & and %

See Also