Varchar variable is not working in WHERE clause

by

Because when you declare, default varchar length is 1. So @MyVarchar ends up being 'A'.

This is different to cast(something as varchar), where default length is 30.

The right thing is

DECLARE @MyVarchar varchar(10) = 'ABCDEF';

where 10 is the length of the column in the table.

More Related Contents:

  1. SQL NVARCHAR and VARCHAR Limits
  2. How do you use script variables in psql?
  3. Calculating distance between two points (Latitude, Longitude)
  4. How do I use variables in Oracle SQL Developer?
  5. How to declare variable and use it in the same Oracle SQL script?
  6. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  7. Declare variable in SQLite and use it
  8. T-SQL split string based on delimiter
  9. Partition Function COUNT() OVER possible using DISTINCT
  10. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  11. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  12. How to return the output of stored procedure into a variable in sql server
  13. CASE WHEN statement for ORDER BY clause
  14. How to get last 7 days data from current datetime to last 7 days in sql server
  15. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  16. Reference an alias elsewhere in the SELECT list
  17. Count Returning blank instead of 0
  18. How to Split String by Character into Separate Columns in SQL Server
  19. Coldfusion – variable field name when looping through database query results
  20. Using IF ELSE statement based on Count to execute different Insert statements
  21. Passing dynamic order by in stored procedure
  22. move cells left in sql if left contains null and right contains value
  23. Select SQL Server database size
  24. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  25. How do I find the data directory for a SQL Server instance?
  26. How to return default value from SQL query
  27. Store and reuse value returned by INSERT … RETURNING
  28. How to concatenate all columns in a select with SQL Server
  29. T-SQL calculate moving average
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment