Declare variable in varchar type : varchar « Data Type « SQL Server / T-SQL






Declare variable in varchar type

1> -- DIFFERENCE: work out when one string sounds similar to another string.
2>
3> -- '0' means that the two strings aren't even close,
4> -- '4'   means a perfect match
5>
6> DECLARE @s1 varchar(6)
7> DECLARE @s2 varchar(6)
8> SET @s1 = "Dewson"
9> SET @s2 = "Joosun"
10>
11> SELECT DIFFERENCE(@s1,@s2)
12> GO

-----------
          3

(1 rows affected)
1>

           
       








Related examples in the same category

1.Specifying Variable-Width Data Types for Table Columns
2.varchar type parameter