Declaring a LOB Datatype

Use the declare function to declare an LOB datatype for a local variable.

declare @variable LOB_datatype

Example 1

This example declares the text_variable as text datatype:
declare @text_variable text