Finding the length of the data field on a SQL table

[sivi]

I am trying to find the lenth of the data field from within a query rather than using the design time literal value of the field length.

a.datafield1+replicate('0',4-len(a.datafield2))+a.datafield2

Here I have used the literal value '4'.

I would be grateful if someone could help me to get this value using an SQL function or something similar. Because this field length could be changed in the future.

Many thanks in advance

Sivi

 

[tlbroadbent]

You can use the ColumnProperty function.

ColumnProperty(object_id('table_name'), 'column_name', 'Precision') Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sivi]

Terry

Thanks for your help.

I hope to get it working.

Sivi