SQL Select: display only the first 500 characters from the start of the line where code like '%'Determine part ID for ...%'
Posted on 2010-08-22
Thanks CyberKiwi! I have a similar question…
The table FormDefinitions is as follows:
xaoCode contains over 900 lines of VBScript code. So doing a basic SQL select isn't very helpful when I only want to view only parts of the VBScript code.
I would like to get SQL Server 2008 to display the xaoCode values from the start of the line…
where like ‘%'Determine part ID for Product version and installation - for base price lookup%’
and onwards for the first 500 characters