Compare string size

[knela]

Hello! How can I compare a table field size with a string?

 

[gmmastros]

You can get the table's field size by querying against the information_Schema.Columns view.

select * from Information_Schema.Columns

Or....

Declare @Size Int

Select @Size = Character_Maximum_Length
From   Information_Schema.Columns
Where  Table_Name = 'YourTableName'
       And Column_Name = 'YourColumnName'

If @Size >= Len(@YourString)
  Begin
    Select 'String is ok'
  End
Else
  Begin
    Select 'String is too long'
  End

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom