Good SQL Formu

[irasmith]

I'll have to admit, that last reply had me chuckling.

 

All righty then I'll give it a go here and see what we can come up with.

 

I am looking to do something in a trigger. Part of what I need to do is find the length of a particular string of data that is being accessed in the SQL database.

 

In looking over some of the string functions, I don't see anything that specifically indicates it is a function to return the lenght of the string in question.

 

Keep in mind, that since I am looking to do this in a trigger I am not referencing any VB.NET code and so I don't have any of the VB.NET functions available to me where I am trying to do this at.

 

Any thoughts or suggestions on this?

Thanks :cool:

[Robby]

You can use Len() ...

len([ColumnName])

[irasmith]

Thanks for the suggestion, I will give it a try and see how it goes.