General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Now the problem with this is it will retrieve '011' or '0122' or wherever is after that. I don't want that. I only want the value of '01'
>What function can I use to do this? Or how can I say that in my SELECT?
I dunno how SQL Server works really, but if its anything like FoxPro, try padding the property with spaces:
padr(Thisform.MyProperty, 7)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only