What does <> "~" mean in SQL

sql stored-procedures tilde
dixienormous picture dixienormous · Aug 30, 2013 · Viewed 13.8k times · Source

I have an SP and part of it states this:

    AND t_phlcm.VAT_FG  <>  "~"

Can you explain the <> "~" part? Does tilde (~) has a special meaning in SQL like % does?

Answer

Ashish Gaur picture Ashish Gaur · Aug 30, 2013

This is an example of simple string comparison which says t_phlcm.VAT_FG must not be equal to "~" character.

Although ~ can be used with regular expressions in Postgres like this :

SELECT * FROM table where name ~ '^ABC'

and is more powerful but is not advised as LIKE(~~) is more fast. Please refer this

Generally speaking ~ is used to complement an integer or bit like this:

Update Users Set [Status] = ~[Status] will invert the status of all users.

Related questions

Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More
Search text in stored procedure in SQL Server

I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_…

Read More
SQL Server - SELECT FROM stored procedure

I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a little more complicated, which is why a sproc is necessary. Is it possible to select the output by …

Read More