Modify length of string field

[BRobinsonS]

I have an application which allowed 35 characters for email address.
Of course, someone has to come up with an email longer than 35 characters.

Is there an elegant way to extend the length to 50 characters?
I have an idea but before I do that is there a way to determine the length first?

That is, if length is 35 then extend to 50 else take no action.
(this assumes the length would only need to be changed at once.)

[Wrangler]

strlen in a conditional statement.

[Gaev]

Brian:

I have an application which allowed 35 characters for email address.
Of course, someone has to come up with an email longer than 35 characters.

Is there an elegant way to extend the length to 50 characters?

I am assuming that ...

- this is a text/string field
- you want to increase the length of the field (column)
- you are amenable to doing it while the Table is NOT Open (adding/editing other records)

... perhaps this suggestion ...

Code: Select all

ALTER TABLE YourTableNameHere
ALTER COLUMN YourColumnnameHere VARCHAR(50)

... that I found here ... https://stackoverflow.com/questions/152 ... -via-t-sql ... might help.

I have an idea but before I do that is there a way to determine the length first?

Pray tell us your idea.

That is, if length is 35 then extend to 50 else take no action.
(this assumes the length would only need to be changed at once.)

I'm confused.

[BRobinsonS]

Since I built SQL execution possibilities into the app, I was able use

Code: Select all

ALTER TABLE YourTableNameHere
ALTER COLUMN YourColumnnameHere VARCHAR(50)

successfully. Wasn't just for myself.

Now I can tell my customers how to change the length if required.
My idea was to use SQL if I could figure out how.
Now I have. I thought I would have to build the SQL into the code, but I don't have to.